Waterfall bar offset graph problem

Sun, 05 Aug 2012 17:38:41 GMT

Dear QV Community

Ia have a problem with a Waterfall Bar graph, the graph has a Dimention (Hierarchical Group (GJ_Concepto) consists of 3 dimensions, "parent level, child level and at sub child level"), has the following expression "Sum({<Base={1},[Bandera concepto]={'SI'}>} [Costo servir])" in th order dimension are =Max(OrdenPresentacion) Ascendig.

The field OrdenPresentacion is number and is related to the last level of the hierarchical group (GJ_Concepto) the bar offset expression is

"rangesum (above(Sum({<Base={1},[Bandera concepto]={'SI'}>} [Costo servir]),-1,rowno()-1))"

This is the result

And this is the desired result

I made this graph write expresion by expression and without dimention

Re: Waterfall bar offset graph problem

richard_pearce6 — Mon, 02 Dec 2013 16:53:23 GMT

Try this:

sum(total Value) - sum(Value)- rangesum(above(sum(Value),1,RowNo()-1))

Re: Waterfall bar offset graph problem

richard_pearce6 — Mon, 02 Dec 2013 16:57:04 GMT

Here's an example

topic Waterfall bar offset graph problem in QlikView

Waterfall bar offset graph problem

Re: Waterfall bar offset graph problem

Re: Waterfall bar offset graph problem