Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Accumulation in qlik sense with multiple dimensions

Hi Experts,

Can anyone please let me know if there is any way to do accumulation in qlik sense with multiple dimensions.

In a straight table i'm using 3 dimensions. Month, Region and Customer. I want to show the expression [Sum(Sales)] by accumulating 3 steps for month. The accumulation should also work for other 2 dimensions.

For single dimension this expression is working rangesum( above( sum([Expression1]),0,rowno())).

How to write expression to accumulate for multiple dimensions.

Please help me to get the solution. I need this very urgent.

 

Thanks in advance.

Regards,

Raju

Labels (1)