Help needed on Waterfall Chart

[Anonymous]

Hi

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?

[#2]

Hi,

Go through the below links it might help u,

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

[#3]

Waterfall Chart Offest Using Dimensions

[#4]

http://qlikshare.com/338/

[ganeshreddy]

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

[Anonymous]

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.