Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Cumulative Filter

Hi,

This is the situation: I have a month filter which I want to work cumulatively to make some calculations.

Example: If have select the month "May" on the filter, the result I want to see is the whole selections of every month up to "May", that means "Jan","Feb","Mar","Apr","May".

Is there any possibility to make that?

Thank you for your attention

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

HI,

Use the following expression

=Sum({<MonthFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)

Regards,

Jagan.

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

HI,

Use the following expression

=Sum({<MonthFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Max(DateFieldName))'}>} Sales)

Regards,

Jagan.

View solution in original post

Highlighted
Not applicable

Thank you very much for your help