topic Re: Waterfall Chart in QlikView

Waterfall Chart

Anonymous — Wed, 19 Nov 2014 12:25:34 GMT

Hi geniuses,

I want to create a waterfall chart for a platform which has several BU something like below image

in this YTD budget can be calculated as sum(Budget)

Actual can be calculated as sum(Actual)

and now I want variance calculated as actual - budget and this variance should be in between budget and actual and is calculated with respect to all the business unit in this platform and also those BU is in form of waterfall

Thanks,

Shashank

Re: Waterfall Chart

jpenuliar — Wed, 19 Nov 2014 12:36:38 GMT

Have a look at a thread regarding waterfall,

Waterfall and changed behaviour of the Total function in QV11

Re: Waterfall Chart

Anonymous — Fri, 21 Nov 2014 11:45:31 GMT

Its not working as I want the YTD Budget and YTD Actuals at the two extremes of the chart

Re: Waterfall Chart

Tue, 07 Apr 2015 15:42:52 GMT

You would not do offsets for the YTD Budget or YTD Actual, for the items in between, you would offset by the columns before, so for example

Offset for BU/Sector 1: Column(1)

Offset for BU/Sector 2: Column(1)+Column(2)

Offset for BU/Sector 3: Column(1) + Column(2) + Column(3)

etc.