Waterfall Chart - Offset Function

[#1]

I have the following expressions and would like to create a waterfall chart -

Total - sum({<[Current Stage] ={'8CAP'}>} [Acquisition Value])

2011 - (sum({<[Current Stage] ={'8CAP'}, [Year] ={'2011'}>} [Acquisition Value]))

2010 - (sum({<[Current Stage] ={'8CAP'}, [Year] ={'2010'}>} [Acquisition Value]))

2009 - (sum({<[Current Stage] ={'8CAP'}, [Year] ={'2009'}>} [Acquisition Value]))

I want the Y-Axis to be the Acquistion value and X-axis to read Total, 2011, 2010 and 2009...I am not sure how to use the bar offset function with the above expressions. Kindly help !

Thanks,

Prakash

[erichshiino]

Hi, Prakash

I created a small sample for you.

http://community.qlik.com/media/p/176323.aspx

Please, on the expressions, please check the bar offset expression.

I also disabled the 'Show legend' option on presentation, so I would have expressions names on the x-axis.

Please, tell me if it works for you.

Rgds,

Erich

[#3]

Thanks Erich for developing this model for me.. If I copy paste this chart and apply the expressions I am not getting a waterfall chart instead I am getting a normal bar chart...I looked at your script and it is a simple inline statement for 2 columns, my dataset is also very similar to what you have and contains 2 columns Year and Aquisition Variance. But both my columns contains blank inbetween values, not sure if that is causing the problem, I am still not able to figure out what is going wrong..Again thanks a lot for your time and effort !

[#4]

hi Eiprakash,

Have you checked the following:

Expressions tab, expand your expressions and check you have script in each of the "Bar offset"?

[#5]

Hello Rich !

Thank you very much that solved the problem !

Prakash

[erichshiino]

Hi,

You probably need to rebuild the bar offset expression.

Imagine that the 2011 result is offset by the total minus 2011 or this could be 2009+2010

I'm trying to include a screnshot of this, I don't know if it will work.

If you still have problems, send us a sample of your data.

[#7]

Erich,

This is perfect, I solved the problem.

Thanks again for your help !

Prakash