topic Re: Previous Year in QlikView https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541558#M688665 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">monthname</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AddYears</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(),-1))),'MMM YYYY')&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;">or </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">monthname</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AddMonths</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(),-12))),'MMM YYYY')&nbsp; </SPAN></P><P></P><P></P></BODY></HTML> Tue, 29 Oct 2013 11:30:51 GMT rajni_batra 2013-10-29T11:30:51Z Previous Year https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541557#M688664 <HTML><HEAD></HEAD><BODY><P>This statement gives me current year, but I need previous year.&nbsp; What do I need to change to get it.</P><P>Thanks</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Date</SPAN><SPAN style="font-size: 12pt;">((<SPAN style="color: #0000ff;">monthname</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN></SPAN><SPAN style="font-size: 12pt;">())-1),'MMM YYYY') </SPAN></P><P></P></BODY></HTML> Tue, 29 Oct 2013 11:25:05 GMT https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541557#M688664 tmumaw 2013-10-29T11:25:05Z Re: Previous Year https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541558#M688665 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">monthname</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AddYears</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(),-1))),'MMM YYYY')&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;">or </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">monthname</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AddMonths</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(),-12))),'MMM YYYY')&nbsp; </SPAN></P><P></P><P></P></BODY></HTML> Tue, 29 Oct 2013 11:30:51 GMT https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541558#M688665 rajni_batra 2013-10-29T11:30:51Z Re: Previous Year https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541559#M688666 <HTML><HEAD></HEAD><BODY><P>Like below</P><P></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Year(Date)-1 OR</SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Date(Year(Today())-1, 'YYYY')&nbsp; OR</SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;">=Year(Date(Year(Today()))-1 )</SPAN><BR /></SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P></BODY></HTML> Tue, 29 Oct 2013 11:33:32 GMT https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541559#M688666 israrkhan 2013-10-29T11:33:32Z Re: Previous Year https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541560#M688667 <HTML><HEAD></HEAD><BODY><P>Thanks Rajni.....just what I needed.</P></BODY></HTML> Tue, 29 Oct 2013 11:38:31 GMT https://community.qlik.com/t5/QlikView/Previous-Year/m-p/541560#M688667 tmumaw 2013-10-29T11:38:31Z