Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Waterfall chart bar graph order problem

HI Dear Community

I have a Waterfall Bar Graph With this expression (QV 10SR4 x64)

  Sum ({<Año_Ventas={$(=Max(Año_Ventas))}>}   [Valor de venta])/1000000

- Sum ({<Año_Ventas={$(=Max(Año_Ventas)-1)}>} [Valor de venta])/1000000

And This dimention

  Linea de Venta

In the Offset Bar Expression i have this expression

  If([Orden de Linea de Venta]=9,0,

  rangesum (above((Sum ({<Año_Ventas={$(=Max(Año_Ventas))}>}   [Valor de venta])/1000000

                           -Sum ({<Año_Ventas={$(=Max(Año_Ventas)-1)}>} [Valor de venta])/1000000),1,rowno()-1)))

The Field [Orden de Linea de Venta]=9  indicates the Total of expression per Linea de Venta Dimention values

Orden  de Linea de VentaLinea de Venta
1Osteosintesis General
2Columna
3CMF
4Mano y Miembro  Superior
5Biomateriales
6Motores y Accesorios
7Productos Especiales
9Total Linea de Venta

The order of Dimention is  Y Value Ascending

This is the result of Graph

Waterfall.png

I need the graph in order to Size of columns Like to the next graph

Waterfall2.png

Thanks for the Help

1 Solution

Accepted Solutions
stephen-a_redmo
Valued Contributor II

Re: Waterfall chart bar graph order problem

Hi Marcos,

The way that you have it sorted is logically correct for the waterfall.  The second bar should start below the line because it is a positive that is counter-acting the negative of the first bar.  It is in the correct position.

I would be asking what, exactly, are you trying to achieve with the visualisation?  Just an ordered bar chart might do the trick?

Regards,

Stephen

6 Replies
chauhans85
Esteemed Contributor

Waterfall chart bar graph order problem

go to sort tab in chart properties and

uncheck all check box

and

select dimension fieldd and check Y value ascending

hope this helps

stephen-a_redmo
Valued Contributor II

Waterfall chart bar graph order problem

Hi Marcos,

If I have to do a Waterfall chart, I generally just do the bars as separate expressions - much easier to deal with.

Regards,

Stephen

Not applicable

Re: Waterfall chart bar graph order problem

Dear Community

I changed the order per Expression Ascending (The same formula of expression)

  Sum ({<Año_Ventas={$(=Max(Año_Ventas))}>}   [Valor de venta])/1000000 - Sum ({<Año_Ventas={$(=Max(Año_Ventas)-1)}>} [Valor de venta])/1000000

And i obtain this graph is close to my objetive but i need the exactly objetive

Waterfall3.png

Not applicable

Re: Waterfall chart bar graph order problem

Thanks for the answer Stephen Redmond ,

Yes i normally y use this option but with this Option How can i order the bars depends of Value?

stephen-a_redmo
Valued Contributor II

Re: Waterfall chart bar graph order problem

Hi Marcos,

The way that you have it sorted is logically correct for the waterfall.  The second bar should start below the line because it is a positive that is counter-acting the negative of the first bar.  It is in the correct position.

I would be asking what, exactly, are you trying to achieve with the visualisation?  Just an ordered bar chart might do the trick?

Regards,

Stephen

Not applicable

Re: Waterfall chart bar graph order problem

HI Stephen

I analyzed the results of the graph and the way the bars are presenting is correct, due to the negative value, the end user might be confused to see the positive value below the zero axis, I will explain as to why this happens and I understand


Thank you very much for your kind help.

Community Browser