Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Waterfall chart with relative values

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

2 Replies
swuehl
MVP
MVP

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

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)