topic Re: How can read last 8 months data in QlikView https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616610#M1097085 <HTML><HEAD></HEAD><BODY><P>I want to use variable in place of the formula in expression.</P></BODY></HTML> Thu, 24 Apr 2014 17:29:00 GMT 2014-04-24T17:29:00Z How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616606#M1097081 <HTML><HEAD></HEAD><BODY><P>I Want to display a last 8 months data in the expression using SET analysis.</P><P></P><P><BR /> </P></BODY></HTML> Thu, 24 Apr 2014 16:37:09 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616606#M1097081 2014-04-24T16:37:09Z Re: How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616607#M1097082 <HTML><HEAD></HEAD><BODY><P>Write like</P><P></P><P></P><P>=Sum({$&lt;MonthYear = {"&gt;$(=num(AddMonths(today(),-9))) &lt;=$(=Num(addmonths(today(),-1)))"}&gt;} YourSalesValue)</P></BODY></HTML> Thu, 24 Apr 2014 16:38:01 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616607#M1097082 its_anandrjs 2014-04-24T16:38:01Z Re: How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616608#M1097083 <HTML><HEAD></HEAD><BODY><P>Can i used it for any Dimension like months and monthname.</P></BODY></HTML> Thu, 24 Apr 2014 16:40:10 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616608#M1097083 2014-04-24T16:40:10Z Re: How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616609#M1097084 <HTML><HEAD></HEAD><BODY><P>Yes you can use it for any expression or dimension.</P></BODY></HTML> Thu, 24 Apr 2014 16:46:26 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616609#M1097084 its_anandrjs 2014-04-24T16:46:26Z Re: How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616610#M1097085 <HTML><HEAD></HEAD><BODY><P>I want to use variable in place of the formula in expression.</P></BODY></HTML> Thu, 24 Apr 2014 17:29:00 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616610#M1097085 2014-04-24T17:29:00Z Re: How can read last 8 months data https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616611#M1097086 <HTML><HEAD></HEAD><BODY><P>Create two variables like</P><P></P><P>vStart&nbsp; =num(AddMonths(today(),-9))</P><P>vEnd =Num(addmonths(today(),-1))</P><P></P><P>And then use script like</P><P></P><P>=Sum({$&lt;MonthYear = {"&gt;$(vStart) &lt;=$(vEnd)"}&gt;} Sales)</P></BODY></HTML> Thu, 24 Apr 2014 17:31:29 GMT https://community.qlik.com/t5/QlikView/How-can-read-last-8-months-data/m-p/616611#M1097086 its_anandrjs 2014-04-24T17:31:29Z