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

    Rangesum and variables

    Fabiana Iglesias



      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.