topic Waterfall Chart - Offset Function in QlikView

Waterfall Chart - Offset Function

Thu, 14 Apr 2011 17:05:57 GMT

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

Waterfall Chart - Offset Function

erichshiino — Fri, 15 Apr 2011 03:55:53 GMT

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

Waterfall Chart - Offset Function

Fri, 15 Apr 2011 14:30:07 GMT

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 !

Waterfall Chart - Offset Function

Fri, 15 Apr 2011 14:37:08 GMT

hi Eiprakash,

Have you checked the following:

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

Waterfall Chart - Offset Function

Fri, 15 Apr 2011 14:43:24 GMT

Hello Rich !

Thank you very much that solved the problem !

Prakash

Waterfall Chart - Offset Function

erichshiino — Fri, 15 Apr 2011 14:44:30 GMT

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.

Waterfall Chart - Offset Function

Fri, 15 Apr 2011 14:46:28 GMT

Erich,

This is perfect, I solved the problem.

Thanks again for your help !

Prakash