how to show the cumulative Value for missing days? - Qlik Community

Amber · ‎2020-08-27

Hi,

does someone have an idea, how to show the cumulative Sum for the missing days? In this Example the cumulative Sum on 22.02. and 23.02. should take the value on 21.02.

Brett_Bleess · ‎2020-09-08

Believe the first step is going to be to get a master calendar in the data model, so you have all the dates, that may be all you need here given it seems you may be accumulating already, but I am not sure:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Kushal_Chawda · ‎2020-09-08

@Amber see the attached file

Amber · ‎2020-09-09

it works !!! Thanks a lot for the supporting.