topic Previous Month Data in QlikView https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957493#M328882 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how do i create a report for just showing only</P><P></P><P>Data for previous month while we are on current month</P><P></P><P>e.g Sales,Date</P><P></P><P>by using addmonths function or any logic that can be applied.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Tue, 29 Sep 2015 11:24:02 GMT 2015-09-29T11:24:02Z Previous Month Data https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957493#M328882 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how do i create a report for just showing only</P><P></P><P>Data for previous month while we are on current month</P><P></P><P>e.g Sales,Date</P><P></P><P>by using addmonths function or any logic that can be applied.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Tue, 29 Sep 2015 11:24:02 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957493#M328882 2015-09-29T11:24:02Z Re: Previous Month Data https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957494#M328883 <HTML><HEAD></HEAD><BODY><P>Similar discussion here: <A href="https://community.qlik.com/message/833886">Retrieving previous months data based on selection</A></P></BODY></HTML> Tue, 29 Sep 2015 12:31:45 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957494#M328883 tresB 2015-09-29T12:31:45Z Re: Previous Month Data https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957495#M328884 <HTML><HEAD></HEAD><BODY><P>=SUM({&lt;InvoiceMonth=, InvoiceYear=, InvoiceQuarter=,&nbsp; InvoiceDate = {"&gt;=$(=Date(MonthStart(Today(),-1)))&lt;=$(=Date(MonthEnd(Today(),-1)))"}&gt;}Sales)</P><P></P><P>Change Fieldnames accordingly...</P></BODY></HTML> Tue, 29 Sep 2015 12:42:10 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957495#M328884 MK_QSL 2015-09-29T12:42:10Z Re: Previous Month Data https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957496#M328885 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Thanks it works i used the solution for Manish!!</P><P></P><P></P><P></P><P>Thanks alot.</P></BODY></HTML> Tue, 29 Sep 2015 12:52:49 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957496#M328885 2015-09-29T12:52:49Z Re: Previous Month Data https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957497#M328886 <HTML><HEAD></HEAD><BODY><P>Please close this thread by marking a correct answer so that it will be helpful for others</P></BODY></HTML> Tue, 29 Sep 2015 12:58:29 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Data/m-p/957497#M328886 sasiparupudi1 2015-09-29T12:58:29Z