Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

Waterfall chart using a stacked bar chart

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.

waterfall.png

3 Replies
jobsonkjoseph
Creator III
Creator III

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

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,

thabang_petje
Partner
Partner