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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulated value according to selection

Hello,


I need to show the panel the cumulative figures for the year to the selected month.

See the attached model.

1 Solution

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

You can use Set analysis like that:

=Sum({<Month={"<=$(=Max(Month))"}, Year_N={"$(=Max(Year_N))"}>} Vol)

Regards,

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

You can use Set analysis like that:

=Sum({<Month={"<=$(=Max(Month))"}, Year_N={"$(=Max(Year_N))"}>} Vol)

Regards,

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
Not applicable
Author

Thank you!