Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
PK422
Contributor II
Contributor II

Cumulative of months of the financial year (Apirl-March)

I have sum of sales based every of month for 2years now I want cumulative of starting of the year to current selected month year

Ex: if i select August 2022 then it show me April2022+May2022+June2022+July 2022+August 2022

I have column like start date , end date,monthyear (mmm-Yy),sum(sales)

 

Labels (3)
3 Replies
maheshkuttappa
Creator II
Creator II

Try this, There are other ways to handle this also. 

Sum({<monthyear ={">=$(=YearStart(FirstSortedValue(distinct monthyear,monthyear),0,4)) <=$(=IF(GetSelectedCount(monthyear)=0, YearEnd(FirstSortedValue(distinct monthyear,monthyear)),Max(monthyear)))"}>}Sales)

maheshkuttappa
Creator II
Creator II

@PK422 were you able to solve this using the above expression?

PK422
Contributor II
Contributor II
Author

Its working but i used different one

any way Thank you!!