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 III
Creator III

Chart with monthly gross and cummulative gross ?

Hi All ,

I got the Aug Gross and Sep Gross measures , how should the Aug Gross Cummulative and Sep Gross Cummulative figures work like below image.?

 

clipboard_image_0.png

 

sample model attached.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Chart with monthly gross and cummulative gross ?

Hi, for cummulative sum, can you try this :

Rangesum(
above(
Sum({< TransMonth = {"$(vMaxMonth)"},TransYear= {"$(vMaxYear)"}>}GROSS_CLAIMS_PAID)

,0,Rowno(total)))

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Re: Chart with monthly gross and cummulative gross ?

Please kindly see , if my Measures -'Sep Gross Cumm' and 'Aug Gross Cumm' is correct.

 

clipboard_image_0.png

 

 

Highlighted
Partner
Partner

Re: Chart with monthly gross and cummulative gross ?

Hi, for cummulative sum, can you try this :

Rangesum(
above(
Sum({< TransMonth = {"$(vMaxMonth)"},TransYear= {"$(vMaxYear)"}>}GROSS_CLAIMS_PAID)

,0,Rowno(total)))

View solution in original post