11 Replies Latest reply: Sep 13, 2018 8:18 AM by Frederic Bonnet RSS

    Rangesum in Pivot table

    Frederic Bonnet

      hi,

      i'd like to build a cumulated sum in a pivot table under Qlik Sense

      Script :

       

      load * inline [Date,Site,Value,

      '01/01/2018','Paris',10

      '02/01/2018','Paris',20

      '04/01/2018','Paris',50

      '01/01/2018','Nice',100

      '03/01/2018','Nice',77];

       

       

      in the Pivot table , i use Site and Date as dimension and the usual expression for cuulated sum :

      =Rangesum(before(sum(Value),0,Month(Date)))

       

      this is what i obtain in Qlikview

      QV.PNG

       

      this is what i obtain in QlikSenseQS.PNG

      the problem is : Sense does not compute the cumulated value when there is no data for the given month and the site

       

      how can i make it in Sense  (as in Qlikview)?

       

      Many thanks in advance

      Frédéric