Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

YTD Calculation-Using Quarterly Data


Hi,

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.

Requirement:

YTD

QoQ

YTDvs PY growth in %

QoQ vs PY growth in %

Thanks and Regards,

Akshay Rai

Community Browser