Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor 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
Highlighted
Contributor III

Re: Waterfall chart using a stacked bar chart

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

Re: Waterfall chart using a stacked bar chart

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,

Partner
Partner

Re: Waterfall chart using a stacked bar chart