Get last value of accumulated in Qlik sense

[phongnnguyen]

Hi guys,

I want to get last value of accumulated

Like that

Account	Date	Value	Accumulate
A	1/1/2018	10	10
A	2/1/2018	9	19
A	3/1/2018	4	23
B	1/1/2018	5	5
B	2/1/2018	2	7
B	3/1/2018	7	14

I just want to last value in this example are A = 23 and B = 14

Thanks for your help

[isorinrusu · Accepted solution]

Hi Phong,

You could have an expression like sum(Value) as your Accumulate and another one as max(Date) instead of Date being a dimension.

So your dimension would be Account, the first expression Date(max(Date)) and the second expression sum(Value).

Regards,

Sorin.