Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-19 08:04 PM

Stack bar, fill columns on continuous date dimension

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:

Fill_Bar_Chart_Dimensions.png

And this is what I expect:

Fill_Bar_Chart_Dimensions_Excel.png

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!!!

Preview file
20 KB
293 Views
0 Likes
0 Replies