topic Re: 12 month Rolling trend in QlikView https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464703#M699529 <HTML><HEAD></HEAD><BODY><P>If there is multiple date fields which needs to be shown the 12 month trend</P><P>and how can we make use of variables up here?</P><P></P><P>eg:</P><P></P><P>process date</P><P></P><P>pending date</P><P></P><P>complete date</P><P></P><P>12 month trend to each field.</P><P></P><P></P><P>On Sun, Nov 25, 2012 at 11:53 PM, Johannes Sunden</P></BODY></HTML> Mon, 26 Nov 2012 15:54:15 GMT 2012-11-26T15:54:15Z 12 month Rolling trend https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464701#M699527 <HTML><HEAD></HEAD><BODY><P>How to get 12 month rolling trend from a date field in the script? </P></BODY></HTML> Mon, 26 Nov 2012 04:05:04 GMT https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464701#M699527 2012-11-26T04:05:04Z Re: 12 month Rolling trend https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464702#M699528 <HTML><HEAD></HEAD><BODY><P><EM>If(DATEFIELD&gt;addmonths(Today(), -12), 1) as Rolling12MonthsFlag</EM></P><P></P><P>Then you can use Set Analysis with your new calendar flag field to only look at the rolling 12 months.</P><P></P><P>If you have future dates as well:</P><P><EM>If(DATEFIELD&gt;addmonths(Today(), -12) and DATEFIELD&lt;=Today(), 1) as Rolling12MonthsFlag</EM></P></BODY></HTML> Mon, 26 Nov 2012 04:53:01 GMT https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464702#M699528 Anonymous 2012-11-26T04:53:01Z Re: 12 month Rolling trend https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464703#M699529 <HTML><HEAD></HEAD><BODY><P>If there is multiple date fields which needs to be shown the 12 month trend</P><P>and how can we make use of variables up here?</P><P></P><P>eg:</P><P></P><P>process date</P><P></P><P>pending date</P><P></P><P>complete date</P><P></P><P>12 month trend to each field.</P><P></P><P></P><P>On Sun, Nov 25, 2012 at 11:53 PM, Johannes Sunden</P></BODY></HTML> Mon, 26 Nov 2012 15:54:15 GMT https://community.qlik.com/t5/QlikView/12-month-Rolling-trend/m-p/464703#M699529 2012-11-26T15:54:15Z