topic Re: YTD Calculation In Pivot table with Year as dimension in QlikView

YTD Calculation In Pivot table with Year as dimension

ashish_2511 — Wed, 25 Nov 2020 16:16:04 GMT

Hi There..

I am having a problem with YTD - # of customers calculation in a pivot table with Year as dimension. Here's the scenario -

Number of new customer = YTD Customer - last year end total customer ,data required here for current year and previous 3 years
for example if the report is run on 1^st July 2016 , it is required to get number of customers on 1^st July 2013 & 1^st July 2014 & 1^st July 2015 and 1^st July 2016 ,

New customer for 2016 = number of customers on 1^st July 2016 – number of total customer by 31 Dec 2015 .

New customer for 2015 = number of customers on 1^st July 2015– number of total customer by 31 Dec 2014 .

New customer for 2014 = number of customers on 1^st 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

2013 100

2014 202

2015 375

2016 867

****I've a nice master calendar with all required fields except YTD flags.

Please advise.

Gysbert_Wassenaar — Wed, 21 Sep 2016 07:22:03 GMT

My advice:

Please read these two documents:

ashish_2511 — Wed, 21 Sep 2016 07:58:31 GMT

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.

Regards

-Sneh

Anonymous — Mon, 25 Dec 2017 05:00:12 GMT

Hi Snehasis,

How did you solve the problem? can you help me on this. I am facing the same issue.

Regards,

Sonthu