topic Re: Waterfall chart using a stacked bar chart in QlikView

Waterfall chart using a stacked bar chart

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

Hi,

I need to create a waterfall chart using a stacked bar chart that shows me two categories of customers - Flag 1 and 0. The objective is to achieve a result like showed in the image below. But I’m trying to use the offset option with a stacked bar chart but I’m not getting any results.

I need help to arrange the bars to look like waterfall using bar offset. Please do help.

Attached my sample file and dataset.

Re: Waterfall chart using a stacked bar chart

jobsonkjoseph — Tue, 20 Nov 2018 09:21:55 GMT

Hi, Would you mind sharing the expressions used in the chart. I'm not table to open the qvw file.

Re: Waterfall chart using a stacked bar chart

Anonymous — Tue, 20 Nov 2018 10:58:10 GMT

Hi,

Expression1 = Count(DISTINCT {<Customer=E(Customer),Field=P(Field),Flag={"1"}>} Field)

Expression2 = Count(DISTINCT {<Customer=E(Customer),Field=P(Field),Flag={"0"}>} Field)

Thanks,

Re: Waterfall chart using a stacked bar chart

Anonymous — Wed, 21 Nov 2018 06:08:33 GMT

Hi,

Please look at:

http://analyticsandeverythingelse.blogspot.com/2016/02/qlikview-waterfall-tutorial.html