Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

christophebrault
Valued Contributor

Offset bar in bar chart with dimensions

Hi,

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.

Thanks

Tags (1)
6 Replies
rajni_batra
Valued Contributor

Re: Offset bar in bar chart with dimensions

Anything like this????

christophebrault
Valued Contributor

Offset bar in bar chart with dimensions

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.

rajni_batra
Valued Contributor

Re: Offset bar in bar chart with dimensions

PFA

christophebrault
Valued Contributor

Re: Offset bar in bar chart with dimensions

No...

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...

christophebrault
Valued Contributor

Re: Offset bar in bar chart with dimensions

No solution ? I'm always looking for...

qliksus
Valued Contributor

Offset bar in bar chart with dimensions

Hi add this in the Barr offset expression

if( isnull(Above(sum(Result))),0, Above(sum(Result)))

Community Browser