topic Re: Waterfall chart Issue in QlikView

Waterfall chart Issue

Thu, 08 Oct 2015 04:40:44 GMT

Hi Team,

We are trying to achieve waterfall chart using bar chart with 1 Dimension and 1 Expression.

Dimension is having 2 fix bar and others are dynamic based on Filter selection.

Logic is : last Bar = SUM of all bar.

we have achieved waterfall behavior as below.

But the issue is, we have 2 bar with higher values, so respectively others are like simple line. So, we are trying to manipulate this to distinguish middle bars.

Option we tried:

Add some fraction of Budget and middle bars and same with offset.

After applied option:

Chart Behavior is not like waterfall chart.

Kindly help me out for this.

Thanks

Ravi Balar

Re: Waterfall chart Issue

Gysbert_Wassenaar — Thu, 08 Oct 2015 05:20:49 GMT

Well, bars should really start on 0, but you can overrule this by disabling the Forced 0 setting of the Expression axis on the Axes tab of the properties window of the chart.

Re: Waterfall chart Issue

Thu, 08 Oct 2015 06:41:25 GMT

Thanks Gysbert. Actually, Forced 0 is not giving excepted output.

So we are trying with Min-Max Scaling.