Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Cumulative Filter

HI,

Use the following expression

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

Regards,

Jagan.

2 Replies
MVP
MVP

Re: Cumulative Filter

HI,

Use the following expression

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

Regards,

Jagan.

Not applicable

Re: Cumulative Filter

Thank you very much for your help

Community Browser