topic Re: Cumulative Filter in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444257#M565167 <HTML><HEAD></HEAD><BODY><P> HI,</P><P></P><P>Use the following expression</P><P></P><P>=Sum({&lt;MonthFieldName=, DateFieldName={'&gt;=$(=YearStart(Max(DateFieldName)))&lt;=$(=Max(DateFieldName))'}&gt;} Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 22 Jan 2013 15:47:33 GMT jagan 2013-01-22T15:47:33Z Cumulative Filter https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444256#M565166 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>This is the situation: I have a month filter which I want to work cumulatively to make some calculations.</P><P>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".</P><P></P><P>Is there any possibility to make that?</P><P></P><P>Thank you for your attention</P></BODY></HTML> Tue, 22 Jan 2013 14:58:09 GMT https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444256#M565166 2013-01-22T14:58:09Z Re: Cumulative Filter https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444257#M565167 <HTML><HEAD></HEAD><BODY><P> HI,</P><P></P><P>Use the following expression</P><P></P><P>=Sum({&lt;MonthFieldName=, DateFieldName={'&gt;=$(=YearStart(Max(DateFieldName)))&lt;=$(=Max(DateFieldName))'}&gt;} Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 22 Jan 2013 15:47:33 GMT https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444257#M565167 jagan 2013-01-22T15:47:33Z Re: Cumulative Filter https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444258#M565168 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your help</P></BODY></HTML> Tue, 22 Jan 2013 16:06:43 GMT https://community.qlik.com/t5/QlikView/Cumulative-Filter/m-p/444258#M565168 2013-01-22T16:06:43Z