topic Re: creating a customized waterfall chart in QlikView

creating a customized waterfall chart

Mon, 08 Dec 2014 09:55:00 GMT

Hi All,

Want to create a waterfall kind of a chart (screenshot attached below). The bars above the line has an offset equal to the first blue colored bar but i am not able to create the bar below the line which the overlap between the first bar & the respective bars.

Any ideas for the same?

Thanks in Advance

Arun

Re: creating a customized waterfall chart

Anonymous — Mon, 08 Dec 2014 10:30:09 GMT

Hello,

Every bar there should be a separate expression.

And then all you need to do is to give offset via expressions->(measure the offset to be given) + -->Bar Offset.

Here you need to write the blue bar's expression so that the offset is given according to it.

Serhan

Re: creating a customized waterfall chart

Mon, 08 Dec 2014 10:33:53 GMT

Thanks for the reply.

I have already done that but my problem is the bar below the line. How to create that bar with a different color?

Thanks

Arun

Re: creating a customized waterfall chart

tresB — Mon, 08 Dec 2014 10:37:09 GMT

Expand the '+' sign of expression label->Background color, you can write expression there like =If(Sum(Sales)>100, red(), green())

Re: creating a customized waterfall chart

Anonymous — Mon, 08 Dec 2014 10:37:14 GMT

Hello,

You can write another condition to Expressions->+-> Background Color.

There are color functions like rgb(), argb ().

You can change the color accordingly.

Serhan

Re: creating a customized waterfall chart

michael_anthony — Mon, 08 Dec 2014 11:00:46 GMT

It is a tough one to do. I think you could achieve it by:

Create a dimension to represent each bar. It doesn't need to link to anything else. Put the dimension in the chart.

Create two expressions as a stacked bar chart. The first one handles the -ve value and can have the offset, using If OR Pick (Match (.....)...,...,....) to calculate each value. The second handles the +ve. You can set the color expression as needed.