Waterfall chart using a stacked bar chart

[Anonymous]

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.

[jobsonkjoseph]

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

[Anonymous]

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,

[Anonymous]

Hi,

Please look at:

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