topic Re: how to set variable on previous year in QlikView https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114534#M763520 <HTML><HEAD></HEAD><BODY><P>Check the attached app:</P></BODY></HTML> Mon, 23 Jul 2018 07:42:53 GMT dapostolopoylos 2018-07-23T07:42:53Z how to set variable on previous year https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114531#M763516 <HTML><HEAD></HEAD><BODY><P>How to set variable on previous year date.</P><P>Example</P><P>when I select a date on date field like '23-Jul-2018' then same time variable value is '23-Jul-2017'.</P><P>Please help me out.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114531#M763516 debabrata_sahoo 2020-11-25T16:16:04Z Re: how to set variable on previous year https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114532#M763517 <HTML><HEAD></HEAD><BODY><H1 style="font-size: 26px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi</H1><P><SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 11.7px; font-family: inherit;"><A href="https://community.qlik.com/people/debabrata.sahoo">debabrata.sahoo</A></STRONG></SPAN></P><P><SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 11.7px; font-family: inherit;"><BR /></STRONG></SPAN></P><P></P><P><SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 11.7px; font-family: inherit;">Datefield:</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">23-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">24-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">25-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">26-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">27-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">28-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">29-Jul-2018</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG style="color: #3d3d3d; font-family: inherit; font-style: inherit; font-size: 11.7px;">Use this in the defination of your variable</STRONG></SPAN></P><P><SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 11.7px; font-family: inherit;">addmonths(getfielsselections(<STRONG style="color: #3d3d3d; font-family: inherit; font-style: inherit; font-size: 11.7px;">Datefield</STRONG>),-12)</STRONG></SPAN></P></BODY></HTML> Mon, 23 Jul 2018 06:59:49 GMT https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114532#M763517 arvind1494 2018-07-23T06:59:49Z Re: how to set variable on previous year https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114533#M763518 <HTML><HEAD></HEAD><BODY><P><STRONG>AddYears</STRONG>(today(), -1)</P><P></P><P>AddYears(Date, -1)</P></BODY></HTML> Mon, 23 Jul 2018 07:27:02 GMT https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114533#M763518 tresB 2018-07-23T07:27:02Z Re: how to set variable on previous year https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114534#M763520 <HTML><HEAD></HEAD><BODY><P>Check the attached app:</P></BODY></HTML> Mon, 23 Jul 2018 07:42:53 GMT https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114534#M763520 dapostolopoylos 2018-07-23T07:42:53Z Re: how to set variable on previous year https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114535#M763521 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AddYears</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(Max(datefildl), -1)</SPAN></P></BODY></HTML> Mon, 23 Jul 2018 07:50:09 GMT https://community.qlik.com/t5/QlikView/how-to-set-variable-on-previous-year/m-p/114535#M763521 fabdulazeez 2018-07-23T07:50:09Z