topic Re: Help needed on Waterfall Chart in QlikView

Help needed on Waterfall Chart

Anonymous — Fri, 18 Sep 2015 09:57:39 GMT

I am trying to plot a waterfall chart with the Demand vs Supply vs Gap between supply and demand . I need to plot the gap the between the demand and supply as another column in the waterfally

My expression are as below -

for Supply : sum(if(W_Type='Supply',HCM))

For Demand: sum(if(W_Type='Supply',HCM))

I now need to plot the gap the gap between demand and supply as a waterfall..When I used the below function as a new Expression

sum((if(w_type='Supply',HCM)) - sum(if(w_Type='Demand',HCM)) and I have the same in the bar offset i am getting the graph as attached.

I need to have these negative bars above the zero axis as positive values and not below 0 as negative values.

Can anybody please help as to what needs to be done?

Re: Help needed on Waterfall Chart

Fri, 18 Sep 2015 10:04:48 GMT

Hi,

Go through the below links it might help u,

http://www.analyticsvidhya.com/blog/2013/12/create-waterfall-chart-qlikview/

Re: Help needed on Waterfall Chart

Fri, 18 Sep 2015 10:05:04 GMT

Waterfall Chart Offest Using Dimensions

Re: Help needed on Waterfall Chart

Fri, 18 Sep 2015 10:05:37 GMT

http://qlikshare.com/338/

Re: Help needed on Waterfall Chart

ganeshreddy — Fri, 18 Sep 2015 10:34:50 GMT

Hi Paktar,

Attach a sample qvw, it looks interesting. in your sample image of water fall segment it is showing demand information instead the difference information. however water fall model is very helpful in showing revenue information in segments.

Ex : segments as dimensions in your case it is totally different.Please attach a sample qvw.

Best Regards,

Ganesh

Re: Help needed on Waterfall Chart

Anonymous — Thu, 24 Sep 2015 11:25:51 GMT

Hi Harshita

I did a bit rejig..i hid the X axis giving a false look of being on the same side of the X axis.