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

    Rangesum in Pivot table

    Frederic Bonnet


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

      Script :


      load * inline [Date,Site,Value,








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



      this is what i obtain in Qlikview



      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