Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I wish to compute the cumulative value for a measure.
In the below table I want to compute the cumulative value for the sales.
can you kindly advise , thanks for the help.
Product | Month | Work day | Sales | Cumulative (expected result) |
A | Jan | 1 | 3 | 3 |
A | Jan | 2 | 4 | 7 |
A | Jan | 3 | 5 | 12 |
A | Jan | 4 | 6 | 18 |
B | Jan | 1 | 4 | 4 |
B | Jan | 2 | 2 | 6 |
B | Jan | 3 | 3 | 9 |
B | Jan | 4 | 4 | 13 |
A | Feb | 1 | 2 | 2 |
A | Feb | 2 | 3 | 5 |
A | Feb | 3 | 7 | 12 |
A | Feb | 4 | 9 | 21 |
B | Feb | 1 | 11 | 11 |
B | Feb | 2 | 13 | 23 |
B | Feb | 3 | 14 | 37 |
B | Feb | 4 | 15 | 52 |
You can try this
Aggr(
RangeSum(Above(
Sum(Sales)
, 0, RowNo()))
, Product, Month, ([Work day], (NUMERIC)))
Dear Sunny,
Thank you for the reply.
I tried this somehow it doesn't work.
The numeric doesn't appear when I type them.
does it need any other step/activation?
Which version of Qlik Sense are you using? Would you be able to share a sample where you can show us the issue?
Hi,
Even below expression would be enough, just set Product, month, work day as dimension in a straight chart and sort accordingly.
RangeSum(Above(
Sum(Sale)
, 0, RowNo()))
Thank you jyothish this worked.
You are welcome 🙂 Please close the thread by marking the correct answer.