Discussion Board for collaboration on QlikView Layout & Visualizations.
In a chart, i'm adding results of differents societies. Number of society changes depending on selections.
I want to have a bar chart ordered form the best to the worst based on results AND an offset for each bar to make a cascade.
The offset must be equal to the precedent society. Look the set of data below.
Anything like this????
Yes, but no....
I want the same result but with only one expression because i have lots of society and hierarchy level, and i can't write an expression for each and because the order will change depending on results for different periods.
the qvw, the order is : C B A D
Offset for C is 0 because it's the first, offset for B = Cresults offset for A = B results etc
i tried to do it with rank, but without success...
No solution ? I'm always looking for...
Hi add this in the Barr offset expression
if( isnull(Above(sum(Result))),0, Above(sum(Result)))