Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
h_prakash
Creator II
Creator II

Applying Date Filter after calulating cumulative

Hi Experts,

I have a flowing requirement where I need to show last three months data after calculating cumulative.

Data is like this and I am looking for from end soultion.

I have calculated cumulative amount using Rangesum(above(total Sum( Amount) , 0, RowNo(Total))).

Date Amount Cumulative Amount
Jan-21 10 10
Feb-21 20 30
Mar-21 30 60
Apr-21 40 100
May-21 50 150
Jun-21 60 210
Jul-21 70 280
Aug-21 80 360
Sep-21 90 450
Oct-21 100 550
Nov-21 110 660
Dec-21 120 780
Jan-22 130 910
Feb-22 140 1050
Mar-22 150 1200
Apr-22 160 1360

 

and I want Data to look like 

Date Amount Cumulative Amount
Jan-22 130 910
Feb-22 140 1050
Mar-22 150 1200
Apr-22 160 1360

 

Any help is appreciated.

 

Thanks

Hari

11 Replies
h_prakash
Creator II
Creator II
Author

Hi Vineeth,

Your expression is working perfectly. In Actual Data I have some missing dates so I have used master calendar. So if I use regular Cumulative expression the running total is showing values for the missing dates. But when I use your expression it showing only for the dates it has.

h_prakash_0-1650954825791.png

 

h_prakash
Creator II
Creator II
Author

It is working Vineeth. Thank you so much.