topic Re: Rolling Of Months for given Data in QlikView https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126735#M898679 <HTML><HEAD></HEAD><BODY><P>Are not in single form? What exactly do you mean/</P></BODY></HTML> Fri, 22 Jul 2016 14:26:16 GMT sunny_talwar 2016-07-22T14:26:16Z Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126734#M898677 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>As i have been attached a excel file&nbsp; SALESDATA&nbsp; and i wanted Sum of [Sales amount] with<STRONG> rolling of 3 months</STRONG></P><P><STRONG>use [Invoice Date] for rolling month purpose.</STRONG></P><P><STRONG> the problem is the dates which are in <STRONG style="font-size: 13.3333px;">[Invoice Date] are not in single form.</STRONG></STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;">pls help me out.</STRONG></STRONG></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126734#M898677 2020-11-25T16:16:04Z Re: Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126735#M898679 <HTML><HEAD></HEAD><BODY><P>Are not in single form? What exactly do you mean/</P></BODY></HTML> Fri, 22 Jul 2016 14:26:16 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126735#M898679 sunny_talwar 2016-07-22T14:26:16Z Re: Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126736#M898682 <HTML><HEAD></HEAD><BODY><P>some are lik MM-DD-YYYY</P><P>and some M/D/YYYY</P></BODY></HTML> Fri, 22 Jul 2016 14:41:50 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126736#M898682 2016-07-22T14:41:50Z Re: Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126737#M898684 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please find the qvw you want...</P><P></P><P>I have used following expression for changing different FORMATS.</P><P></P><P></P><P></P><P>&nbsp; Date#(Date([Invoice Date],'MM/DD/YYYY'),'MM/DD/YYYY') as [Invoice Date]</P><P></P><P></P><P>and</P><P></P><P><STRONG>MonthInvoice&nbsp;&nbsp;&nbsp;&nbsp; (please see the QVW)</STRONG>&nbsp; is the KEY field for SELECTING last 3 months for Rolling&nbsp; sum</P><P></P><P></P><P>Please check and let me know ..</P></BODY></HTML> Fri, 22 Jul 2016 15:34:24 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126737#M898684 Anonymous 2016-07-22T15:34:24Z Re: Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126738#M898686 <HTML><HEAD></HEAD><BODY><P>thanks,</P></BODY></HTML> Fri, 22 Jul 2016 15:36:51 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126738#M898686 2016-07-22T15:36:51Z Re: Rolling Of Months for given Data https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126739#M898688 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>FYI</P><P></P><P>Modified PIVOT TABLE</P><P></P><P></P><P>Please mark this as "Answered' if it is okay for you...</P></BODY></HTML> Fri, 22 Jul 2016 15:49:51 GMT https://community.qlik.com/t5/QlikView/Rolling-Of-Months-for-given-Data/m-p/1126739#M898688 Anonymous 2016-07-22T15:49:51Z