topic 13 month in App Development https://community.qlik.com/t5/App-Development/13-month/m-p/1311189#M27984 <HTML><HEAD></HEAD><BODY><P>Hello All</P><P></P><P>Please help me in the below query. I have the data from Feb'12 to till date.</P><P></P><P>I need to create a bar graph which picks only last 13 month data.</P><P></P><P>I have created a variable as</P><P></P><P>Rolling13 = DATE(MONTHSTART(TODAY(),-13), 'YYYY-MM-DD')</P><P></P><P>Can some one please guide me how to use it in the below formula</P><P></P><P>COUNT(CASES) with dimension as&nbsp; Open Month</P><P></P><P>Please guide</P><P></P><P></P><P>Regards</P><P>DC</P></BODY></HTML> Wed, 12 Apr 2017 18:49:14 GMT Anonymous 2017-04-12T18:49:14Z 13 month https://community.qlik.com/t5/App-Development/13-month/m-p/1311189#M27984 <HTML><HEAD></HEAD><BODY><P>Hello All</P><P></P><P>Please help me in the below query. I have the data from Feb'12 to till date.</P><P></P><P>I need to create a bar graph which picks only last 13 month data.</P><P></P><P>I have created a variable as</P><P></P><P>Rolling13 = DATE(MONTHSTART(TODAY(),-13), 'YYYY-MM-DD')</P><P></P><P>Can some one please guide me how to use it in the below formula</P><P></P><P>COUNT(CASES) with dimension as&nbsp; Open Month</P><P></P><P>Please guide</P><P></P><P></P><P>Regards</P><P>DC</P></BODY></HTML> Wed, 12 Apr 2017 18:49:14 GMT https://community.qlik.com/t5/App-Development/13-month/m-p/1311189#M27984 Anonymous 2017-04-12T18:49:14Z