Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

shashank20
New Contributor III

Waterfall Chart


Hi geniuses,

I want to create a waterfall chart for a platform which has several BU something like below imagewaterfall.JPG.jpg

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

3 Replies
jpenuliar
Valued Contributor III

Re: Waterfall Chart

Have a look at a thread regarding waterfall,

Waterfall and changed behaviour of the Total function in QV11

shashank20
New Contributor III

Re: Waterfall Chart


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

Not applicable

Re: Waterfall Chart

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.

Community Browser