Year To Date Calculation with missing Dates

[Curiosity]

Hello Qlikview Community.

I have a pivot table with the following three columns (+ 3 example values):

[yearmonth] 

201807

201808

201811

[Sales]

1

3

4

[YTD Sales]

1

3

4

The [YTD Sales] values are obviously wrong.

For [Sales] I used the expression: =COUNT(DISTINCT [Sales])

For [YTD Sales] I used the expression: = RANGESUM(Above(Count(DISTINCT [Sales]),0,Num(RIGHT([yearmonth],2))))

The YTD Expression is working on another Pivot Table where I have an entry for every [yearmonth]. Is there a way to show every [yearmonth]? Or do you have an alternative solution?

Thanks very much for the support. 

Greetings

Curiosity

[Curiosity]

Nobody an idea? Is the question not clear enough? Would be happy for any response

Greetings

Curiosity

[PrashantSangle]

Can you explain with required output.  

[Curiosity]

Hi PrashantSangle, 

thanks for your response!

Yes, the required Output would be:

[YTD Sales]

1

4

8

I have multiple Years so if its the same year (here 2018) you accumulate the numbers and next year you should start with the first entry from next year.

Greetings

Curiosity

[Brett_Bleess]

Have a look at the following Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

I believe those should be of some help.

Regards,
Brett