Discussion board where members can get started with QlikView.
I am having a problem with YTD - # of customers calculation in a pivot table with Year as dimension. Here's the scenario -
New customer for 2016 = number of customers on 1st July 2016 – number of total customer by 31 Dec 2015 .
New customer for 2015 = number of customers on 1st July 2015– number of total customer by 31 Dec 2014 .
New customer for 2014 = number of customers on 1st July 2014– number of total customer by 31 Dec 2013 .
Here's a snip from the requirement document.
This actually is 4 years to date calculation.
Output I'm expecting is -
Year #New Customers
****I've a nice master calendar with all required fields except YTD flags.
Please read these two documents:
Thanks a lot for your response Gysbert. Going forward i'll keep these guidelines in mind.
For now i've solved the issue myself. Hence i'm closing this thread.
How did you solve the problem? can you help me on this. I am facing the same issue.