Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative sum of previous quarters

Hi everybody,

I need to calculate the sum of all the previous week, for exemple if quarter 3 is selected and year 2015 is selected , i need to have the cumulative sum of quarter 1 and quarter 2 of 2015.

Here is the table in need to display:

If Quarter 3 is selected I need to have in the column " Cumul T2 Initial " The cumulative Sum of quarter 1 and quarter 2.

NB : there is a special case If Quarter 1 is selected the result must be the sum of all quarters of the last year.

Capture_LI.jpg

Thank You for your help.

0 Replies