topic Previous month in QlikView https://community.qlik.com/t5/QlikView/Previous-month/m-p/1242155#M394386 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a requirement to show sales based on month selected and another column to show sales of previous month of current selected month.Sales for selected Month will be Month(Getfieldselection(ReportMonth)), but not able to understand how to write logic for previous month? Could anyone help me on this?</P></BODY></HTML> Sat, 12 Nov 2016 19:17:04 GMT Anonymous 2016-11-12T19:17:04Z Previous month https://community.qlik.com/t5/QlikView/Previous-month/m-p/1242155#M394386 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a requirement to show sales based on month selected and another column to show sales of previous month of current selected month.Sales for selected Month will be Month(Getfieldselection(ReportMonth)), but not able to understand how to write logic for previous month? Could anyone help me on this?</P></BODY></HTML> Sat, 12 Nov 2016 19:17:04 GMT https://community.qlik.com/t5/QlikView/Previous-month/m-p/1242155#M394386 Anonymous 2016-11-12T19:17:04Z Re: Previous month https://community.qlik.com/t5/QlikView/Previous-month/m-p/1242156#M394387 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to use the set analysis.</P><P></P><P>Find below link for more help.</P><P></P><P></P><P><A href="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting" title="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting">http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting</A></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sat, 12 Nov 2016 19:46:57 GMT https://community.qlik.com/t5/QlikView/Previous-month/m-p/1242156#M394387 kaushiknsolanki 2016-11-12T19:46:57Z