topic Re: Water Fall Bar Chart in QlikView

Water Fall Bar Chart

Thu, 25 Oct 2012 09:46:29 GMT

Hi.

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

How can we do that ?

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 09:51:01 GMT

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.

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 11:21:50 GMT

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.

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 11:29:21 GMT

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.

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 11:31:25 GMT

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

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 11:56:20 GMT

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

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 14:00:45 GMT

Ok. Thanks a lot.

Re: Water Fall Bar Chart

Thu, 25 Oct 2012 21:18:01 GMT

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.