topic Set analisys rolling in QlikView https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258544#M1204183 <HTML><HEAD></HEAD><BODY><P>Create a monthyear field with the funtion MonthName in the script than try something like the expression below:</P><P>sum({$&lt;month=,year=,monthyear={"&gt;$(=monthname(max(monthyear),-12))&lt;=$(=monthname(max(monthyear)))&gt;} QTA)</P><P>Regards.</P></BODY></HTML> Thu, 20 May 2010 01:13:34 GMT pover 2010-05-20T01:13:34Z Set analisys rolling https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258543#M1204182 <HTML><HEAD></HEAD><BODY><P><SPAN closure_uid_c8oswq="278" lc="Devo creare un set analisys che permetta di filtrare 12 mesi precedenti." mc="I have to create a set that allows you to filter analisys previous 12 months." style="background-color: #fff;">I have to create a set that allows you to filter previous 12 months.<BR /><BR /></SPAN> <SPAN closure_uid_c8oswq="279" lc="Ho scritto la seguente espressione ma non è corretta." mc="I wrote the following expression but it is not correct." style="background-color: #fff;">I wrote this expression but it is not correct.</SPAN></P><P><SPAN closure_uid_c8oswq="279" lc="Ho scritto la seguente espressione ma non è corretta." mc="I wrote the following expression but it is not correct." style="background-color: #fff;">expression1:</SPAN></P><P style="margin: 0cm 0cm 0pt;">sum({$&lt;year= {$(=max(year))}, month= {"&lt;=$(=max({&lt;year={$(=max(year))}&gt;} month))&gt;$(=max({&lt;year={$(=max(year))}&gt;} month)-12)"}&gt;} QTA)</P><P><SPAN closure_uid_c8oswq="279" lc="Ho scritto la seguente espressione ma non è corretta." mc="I wrote the following expression but it is not correct." style="background-color: #fff;">ES:<BR /></SPAN> <SPAN closure_uid_c8oswq="282" lc="es se sono al 2010-03 voglio che il set analisys mi filtri fino al 200903 metre questa formula si ferma al 2010-01." mc="eg if I want to 2010-03 analisys I set up filters to 200,903 m in 2010-01 to make stops." style="background-color: #fff;">if I am in 2010-03 period i want set filters from 2010-03 to 2009-03</SPAN></P><P><SPAN closure_uid_c8oswq="282" lc="es se sono al 2010-03 voglio che il set analisys mi filtri fino al 200903 metre questa formula si ferma al 2010-01." mc="eg if I want to 2010-03 analisys I set up filters to 200,903 m in 2010-01 to make stops." style="background-color: #fff;">C</SPAN>an you help ,please?</P></BODY></HTML> Wed, 19 May 2010 22:57:15 GMT https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258543#M1204182 2010-05-19T22:57:15Z Set analisys rolling https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258544#M1204183 <HTML><HEAD></HEAD><BODY><P>Create a monthyear field with the funtion MonthName in the script than try something like the expression below:</P><P>sum({$&lt;month=,year=,monthyear={"&gt;$(=monthname(max(monthyear),-12))&lt;=$(=monthname(max(monthyear)))&gt;} QTA)</P><P>Regards.</P></BODY></HTML> Thu, 20 May 2010 01:13:34 GMT https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258544#M1204183 pover 2010-05-20T01:13:34Z Set analisys rolling https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258545#M1204184 <HTML><HEAD></HEAD><BODY><P>sorry but it is wrong!</P><P>I can not insert my file.qvw in Network</P></BODY></HTML> Thu, 20 May 2010 07:55:47 GMT https://community.qlik.com/t5/QlikView/Set-analisys-rolling/m-p/258545#M1204184 2010-05-20T07:55:47Z