topic Sum in waterfall chart in QlikView

Sum in waterfall chart

Tue, 29 Jun 2010 13:18:08 GMT

I'm trying to create a waterfall graph that accumulates a certain expression sorted descending. I'm using

=above(SUM(Expression)

in my Bar offset resulting in the correct waterfall graph but ruining my sort. For example:

1
2
5
4
3

Should result in a waterfall

5
4
3
2
1

Sum in waterfall chart

Tue, 29 Jun 2010 14:00:10 GMT

Added an example QVW to demonstrate the issue

Department	Value
Marketing	1
Finance	3
Sales	4
HR	2
Facilities	2

AW:Re: Sum in waterfall chart

brenner_martina — Tue, 29 Jun 2010 14:39:14 GMT

Hi Anja,

I do not really understand, what's your problem. Do you want to change the sortorder? You can enter "order by expression" desc value or any other field.

AW:Re: Sum in waterfall chart

Tue, 29 Jun 2010 14:47:50 GMT

I want my waterfall graph to look like this (sorted by Y value ascending), but if you look at the attached QVW in my earlier post the sort is not giving me this result.

Sum in waterfall chart

sicilianif — Tue, 29 Jun 2010 15:04:08 GMT

Put this in your bar offset expression:

If(rowno()=1,0,rangesum (above(sum(Value),1,rowno()-1)))

Then change your sort to be by expression descending and use this:

Sum(Value)

Frank

Sum in waterfall chart

Thu, 06 Jan 2011 23:03:50 GMT

Perfect! Thanks Much

Sum in waterfall chart

Fri, 04 Feb 2011 11:40:43 GMT

Frank,

Many thanks for this tip, exactly what I was looking for (when using only one dimension)!

Kind regards,

Rich

Sum in waterfall chart

Fri, 04 Feb 2011 13:09:02 GMT

A quick question, managed to get the Waterfall chart to display correctly when using one dimension, and sorting by "expression", descending sum(Euros)

When I change the dimension (from "Class") to a calculated dimension:

=if(GetPossibleCount(Family)=1,Class,Family) ,and again sort by descending "sum(Euros)" the following graph is displayed (without displaying the largest values first 😞

Any ideas why the sort is now behaving differently, now a calculated dimension has been added?

Please advise,

Kind regards,

Rich

Sum in waterfall chart

Thu, 14 Apr 2011 20:12:33 GMT

Hello,

Thank you for your solution.

How to offset the Others bar ?

How do you do when you choose to limit the number of values of your dimension (by using the option "Max Visible Number") and you active the "Show Other" option in the Presentation tab ?

Philippe