topic Sales Amt Calculation based on CY and LY in QlikView https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737195#M263631 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to calculate Sales Amount for the attached excel file.</P><P>Condition : It has data up to Aug 2014. So need to calculate Amt for Aug 2013 to Jul 2014.</P><P>When Sept 2014 comes, Amt for Sept 2013 to Aug 2014.</P><P></P><P></P><P>Regards,</P><P>Sivasu</P></BODY></HTML> Fri, 08 Aug 2014 07:04:22 GMT 2014-08-08T07:04:22Z Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737195#M263631 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to calculate Sales Amount for the attached excel file.</P><P>Condition : It has data up to Aug 2014. So need to calculate Amt for Aug 2013 to Jul 2014.</P><P>When Sept 2014 comes, Amt for Sept 2013 to Aug 2014.</P><P></P><P></P><P>Regards,</P><P>Sivasu</P></BODY></HTML> Fri, 08 Aug 2014 07:04:22 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737195#M263631 2014-08-08T07:04:22Z Re: Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737196#M263632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA application, Hope it will work for you.</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Fri, 08 Aug 2014 07:43:23 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737196#M263632 VishalWaghole 2014-08-08T07:43:23Z Re: Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737197#M263633 <HTML><HEAD></HEAD><BODY><P>Thank You so Much.</P><P></P><P>Please can you say me to caluclate the same condition based on Financial Year and Financial Month.</P><P></P><P>Regards.</P><P>Sivasu</P></BODY></HTML> Fri, 08 Aug 2014 09:18:50 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737197#M263633 2014-08-08T09:18:50Z Re: Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737198#M263634 <HTML><HEAD></HEAD><BODY><P>What you want exactly with finance Year and Month...</P><P></P><P>Clarify you requirement.</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Fri, 08 Aug 2014 09:28:45 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737198#M263634 VishalWaghole 2014-08-08T09:28:45Z Re: Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737199#M263635 <HTML><HEAD></HEAD><BODY><P>Your Logic works fine for Calendar Year and Calendar Month.. But the same condition for Financial Year and Financial Month.</P></BODY></HTML> Fri, 08 Aug 2014 09:38:06 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737199#M263635 2014-08-08T09:38:06Z Re: Sales Amt Calculation based on CY and LY https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737200#M263636 <HTML><HEAD></HEAD><BODY><P>If i select Financial Year and Financial Month as 2014 and April. In NewMonthName field, it is selected as Jan2014.</P><P></P><P>Regards,</P><P>Sivasu</P></BODY></HTML> Fri, 08 Aug 2014 09:59:38 GMT https://community.qlik.com/t5/QlikView/Sales-Amt-Calculation-based-on-CY-and-LY/m-p/737200#M263636 2014-08-08T09:59:38Z