Stack bar, fill columns on continuous date dimension

Fri, 20 Sep 2013 00:04:57 GMT

Hi,

I have a set of data that has values for several members of a dimension over time. I need to show the cumulative values in a stack bar but as some members have no values on same dates the graph is not working as expected. Is there a way to fill the gaps with the previous value (or with a zero and the Full Accumulation will take care of it)??

This is what I'm getting:

And this is what I expect:

Attached is the data I'm using. The "Dimension" can have several members that change dynamically so a fixed set of expressions is not going to work.

Thanks!!!

topic Stack bar, fill columns on continuous date dimension in QlikView

Stack bar, fill columns on continuous date dimension