topic Re: Waterfall chart with relative values in QlikView

Waterfall chart with relative values

Anonymous — Tue, 03 May 2016 06:40:51 GMT

Dear all

I need to change the expressions in my waterfall chart into relative expressions . It does not work by simply selecting checkbox "Relative".

I would like to show

Sales =100%

Sales dedcutions=10%

Material cost=20%

...

Thanks a lot for your help

swuehl — Tue, 03 May 2016 12:40:17 GMT

If your sales expression is currently something like

=Sum(Sales)

then try to divide all your expressions by Sum(Sales)

Sales:

=Sum(Sales) / Sum(Sales) // or simply 1

Sales deductions:

=Sum([Sales deductions]) / Sum(Sales)

Material Cost:

=Sum(Cost) / Sum(Sales)

and format the numbers using num() function or on number tab as percentages.

sunny_talwar — Wed, 04 May 2016 02:24:17 GMT

Are you using multiple expressions or just one expression with if statement?

May be you need to do something like this if you have a dimension called Dim for instance

Dim Value

Sales 140

Sales deductions 14

Cost 28

Sum(Value)/Sum(TOTAL {<Dim = {'Sales'}>} Value)