topic Re: How to show previous month. help please. in QlikView https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504106#M692858 <HTML><HEAD></HEAD><BODY><P>Probably easiest if you use some variables. </P><P></P><P>variable vPrevMonth: =date(addmonths(date#(TRANS_YEARMONTH,'YYYY-MM'),-1),'YYYY-MM')</P><P>expression: sum( {$&lt;MONTH=,YEAR=,TRANS_YEARMONTH={'$(vPrevMonth)'},FS={'Sales',"Discount*"} &gt;} DIFF )</P><P></P><P>See attached example.</P><P></P><P>To make things easier you can use Qlikview Components to create a calendar for you and get a lot of handy set modifiers (like previous month) for free. See <A _jive_internal="true" href="https://community.qlik.com/thread/66717" style="font-size: 12px; color: #007fc0; font-family: Arial;">Tutorial - Using Common Date Dimensions and Shared Calendars</A> for more information.</P></BODY></HTML> Sun, 21 Jul 2013 09:50:37 GMT Gysbert_Wassenaar 2013-07-21T09:50:37Z How to show previous month. help please. https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504105#M692857 <HTML><HEAD></HEAD><BODY><P>i want to show value of previous month. but i can't get it and i try follow by forums in qlikview community for this case but it dosen't work.<BR /></P><P>anyone help me please.<BR /></P></BODY></HTML> Sun, 21 Jul 2013 08:48:31 GMT https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504105#M692857 2013-07-21T08:48:31Z Re: How to show previous month. help please. https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504106#M692858 <HTML><HEAD></HEAD><BODY><P>Probably easiest if you use some variables. </P><P></P><P>variable vPrevMonth: =date(addmonths(date#(TRANS_YEARMONTH,'YYYY-MM'),-1),'YYYY-MM')</P><P>expression: sum( {$&lt;MONTH=,YEAR=,TRANS_YEARMONTH={'$(vPrevMonth)'},FS={'Sales',"Discount*"} &gt;} DIFF )</P><P></P><P>See attached example.</P><P></P><P>To make things easier you can use Qlikview Components to create a calendar for you and get a lot of handy set modifiers (like previous month) for free. See <A _jive_internal="true" href="https://community.qlik.com/thread/66717" style="font-size: 12px; color: #007fc0; font-family: Arial;">Tutorial - Using Common Date Dimensions and Shared Calendars</A> for more information.</P></BODY></HTML> Sun, 21 Jul 2013 09:50:37 GMT https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504106#M692858 Gysbert_Wassenaar 2013-07-21T09:50:37Z Re: How to show previous month. help please. https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504107#M692859 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Sun, 21 Jul 2013 14:38:50 GMT https://community.qlik.com/t5/QlikView/How-to-show-previous-month-help-please/m-p/504107#M692859 2013-07-21T14:38:50Z