Water Fall Bar Chart

[#1]

Hi.

I have seen a bar chart in a document prepared by Qlikview like in enclosed PNG file.

How can we do that ?

[#2]

This can be achieved by going to the expression. Unfold the second expression by pressing at the "+" sign. Go to Bar offset and copy the first expression to the expression field. In the bar-offset of the third expression you sum the first AND second expression as offset, and so on.

[#3]

Thanks Patrick, I've got the point but I need more help. For instance, you see there is Revenue and COGS. If I put the revenue expression in COGS expression's offset, COGS  start just lower or upper from revenue's square. I couldn't place it like in that enclosed shape.

[#4]

Hi

Just a point on this, in the chart you have included Revenues are a positive number, all others are negative numbers which is why they start at revenues and drop down.  If you have all numbers as positives then the waterfall chart will, correctly start at the dn point of the previous bar and rise.

Regards,

Nigel.

[#5]

your COGS is the offset of net Income, Tax and Expenses

[#6]

if these both Revenue and COGS are different expressions, then you need to give expression like--(Revenue-COGS) for COGS BarOffset.

Hope it helps.

Thanks & Regards,

Venkat T

[#7]

Ok. Thanks a lot.

[#8]

QlikView has a Data Visulation qvw available which will produces the Water Fall bar chart.  Look at the Share tab.  I believe I got it off of qlik.com.