Cumulative measure

[sathishkumt]

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

[sunny_talwar]

You can try this

Aggr(
   RangeSum(Above(
      Sum(Sales)
   , 0, RowNo()))
, Product, Month, ([Work day], (NUMERIC)))

[sathishkumt]

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?

[sunny_talwar]

Which version of Qlik Sense are you using? Would you be able to share a sample where you can show us the issue?

[jyothish8807]

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()))

[sathishkumt]

Thank you jyothish this worked.

[jyothish8807]

You are welcome 🙂 Please close the thread by marking the correct answer.