7 Replies Latest reply: Mar 2, 2018 10:33 AM by Fabiana Iglesias RSS

    Rangesum and variables

    Fabiana Iglesias

      Hi,

       

      I need to accumulate the results of the expression "Sales*Percentage" in Qlik Sense Desktop.

      I´,ve tried this options:

       

      1. RangeSum(Above($(vSales), 0, RowNo())),

       

      where $(vSales) = sum({<IDAccount={'40'}>}Sales*Percentage

       

       

      2. RangeSum(Above((sum({<IDAccount={'40'}>}Sales*Percentage)), 0, RowNo())),

       

      And I have the results but they are not cummulative

       

      I need a clue to solve this.