topic YTD Calculation-Using Quarterly Data in QlikView https://community.qlik.com/t5/QlikView/YTD-Calculation-Using-Quarterly-Data/m-p/857255#M659363 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I want to calculate YTD, QoQ, YTD previous Year and QoQ Previous Year as growth, list box or Straight Table. PFA the sample files of my data in excel and on qlikview with the load. My data are in quarter form (Q1, Q2, Q3 and Q4) for respective years. So i want a script, where calculation based on quarters. Looking for a perfect solution as its a critical project.</P><P></P><P>Requirement:</P><P>YTD</P><P>QoQ</P><P>YTDvs PY growth in %</P><P>QoQ vs PY growth in %</P><P></P><P>Thanks and Regards,</P><P>Akshay Rai</P></BODY></HTML> Mon, 06 Apr 2015 07:35:45 GMT 2015-04-06T07:35:45Z YTD Calculation-Using Quarterly Data https://community.qlik.com/t5/QlikView/YTD-Calculation-Using-Quarterly-Data/m-p/857255#M659363 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I want to calculate YTD, QoQ, YTD previous Year and QoQ Previous Year as growth, list box or Straight Table. PFA the sample files of my data in excel and on qlikview with the load. My data are in quarter form (Q1, Q2, Q3 and Q4) for respective years. So i want a script, where calculation based on quarters. Looking for a perfect solution as its a critical project.</P><P></P><P>Requirement:</P><P>YTD</P><P>QoQ</P><P>YTDvs PY growth in %</P><P>QoQ vs PY growth in %</P><P></P><P>Thanks and Regards,</P><P>Akshay Rai</P></BODY></HTML> Mon, 06 Apr 2015 07:35:45 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation-Using-Quarterly-Data/m-p/857255#M659363 2015-04-06T07:35:45Z