topic Re: How can i make a cumulation with missing values? in QlikView

How can i make a cumulation with missing values?

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

Hi,

i need to make a balken graph with cumulative values, but the graph doesn't show the right way. For example the "TM 6M" is missing on 25.02.2020, it should take the value of the day before...

Please can someone help?

Thanks a lot.

Re: How can i make a cumulation with missing values?

Frank_Hartmann — Sat, 25 Apr 2020 08:27:26 GMT

try with an as-of table.

As-Of Table

see attached!

Re: How can i make a cumulation with missing values?

Amber — Sun, 26 Apr 2020 13:34:48 GMT

unbelievable, it works, I am mega excited mega excited about the great solution. Thank you so much!

Bests