topic Re: Accumulated value according to selection in QlikView https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492346#M184108 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 18 Oct 2013 19:56:37 GMT 2013-10-18T19:56:37Z Accumulated value according to selection https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492344#M184106 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P><BR />I need to show the panel the cumulative figures for the year to the selected month.</P><P></P><P></P><P>See the attached model.</P></BODY></HTML> Fri, 18 Oct 2013 18:05:57 GMT https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492344#M184106 2013-10-18T18:05:57Z Re: Accumulated value according to selection https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492345#M184107 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>You can use Set analysis like that:</P><P></P><P>=Sum({&lt;<STRONG>Month={"&lt;=$(=Max(Month))"}</STRONG>, <STRONG>Year_N={"$(=Max(Year_N))"}</STRONG>&gt;} Vol)</P><P></P><P>Regards,</P><P>Aurélien</P></BODY></HTML> Fri, 18 Oct 2013 19:13:32 GMT https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492345#M184107 Aurelien_Martinez 2013-10-18T19:13:32Z Re: Accumulated value according to selection https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492346#M184108 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 18 Oct 2013 19:56:37 GMT https://community.qlik.com/t5/QlikView/Accumulated-value-according-to-selection/m-p/492346#M184108 2013-10-18T19:56:37Z