topic Re: Waterfall Chart - Mix Grouped and Stacked Bars in QlikView

Waterfall Chart - Mix Grouped and Stacked Bars

Tue, 15 Nov 2016 11:57:16 GMT

Hello all,

I need to create a waterfall chart looking similar to something like this:

I am having difficulties creating this chart as it seems to be that mixing grouped and stacked bars in the same chart might not be possible.

If I have an expression, and I want to split my expression by the dimension in a stacked bar, the dimension will apply to all my 5 bars in the graph when I only want to apply it to the 2nd and 3rd bar.

Do you have any suggestion on how I should proceed ? I hope I was clear enough.

Thank you !

Re: Waterfall Chart - Mix Grouped and Stacked Bars

sunny_talwar — Tue, 15 Nov 2016 11:59:31 GMT

See if this link helps (Images are not working, but I think you can download the attached qvws to see if one of those help)

Clustered-Stacked Column and Bar Charts in QlikView

Re: Waterfall Chart - Mix Grouped and Stacked Bars

rubenmarin — Tue, 15 Nov 2016 12:30:16 GMT

Hi M V, I did something similar, the number of bars was fixed so I overlapped many different charts, one for the layout and one more for each bar.

Only the chart on the lower layer paints the axis, legends, etc... all the other charts has to have the same axis ranges (you'll need an expression that retrieves the max and min value from all charts -using rangeMax() and RangeMin() can help) and everything set as transparent, the only thing every chart paints is the bar.

Then you'll have to manually move each chart so the bar corresponds with the axis of the "layout chart".

If the number of bars isn't fixed (to 5 in your case) this solution can't work.