Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help on qtd, ytd, yoy qtd, yoy ytd

Hi,

In the attached qvw, can you please help me get the following level of metrics.

All metrics needs to be calculated for the year and month selected and for every Region and Sub Region.

  1. Actual Number, QTD, YTD for the selected month
  2. YoY, QTD YoY, YTD YoY for the selected Month

Thanks for your time.

Regards,

Tina.

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

Here is a sample approach using variables and your existing data model and date dimension.

I completed a full sample set for the PP expression

Capture.PNG.png

View solution in original post

3 Replies
arniewolff
Contributor III
Contributor III

Tina,

Usually, when you need to perform YTD, QTD calculations, you need to create a true master calendar that holds that information in Flag fields. Then you can use the flags to know when to add.

Here's an example of a master calendar that is auto-generated from beginning, end, current date, and LY current date fields. Perhaps this can help?

Arnie

JonnyPoole
Employee
Employee

Here is a sample approach using variables and your existing data model and date dimension.

I completed a full sample set for the PP expression

Capture.PNG.png

Not applicable
Author

Jonathan/Arnie,

Thanks for your time. The solution works perfect.

I have another question. We are trying to replicate the excel sheet table attached in the image. Can you think about a way to get the same format i.e. Have the Monthly, QTD and YTD as columns for each actual metric and its corresponding year over year as rows.

Is that doable. Can you please take a look when you have some time.

Thanks,

Tina.