Pick match function in stacked bar 100%

judikael — Fri, 10 Dec 2021 08:48:41 GMT

Hello,

I use qliksense nov.2018

I create a bar chart with 2 dimensions : year and delay

1 expression :

count(distinct {<type_acte={'Financiere'}, IS_STATUT={0} > } ID_CORREL)

count(distinct {<type_acte={'Financiere'}, IS_STATUT={0} > TOTAL <ANNEES>} ID_CORREL)

when i use pick function like this

Pick(match(delay,'xx','xxx','xxxx','xxxx','xxxx'), rgb(x,x,x) , rgb(),rgb(), rgb(),rgb())

I see a stacked bar to 500%.

How can i solve it ? Without pik match in color and legend i have a 100% stacked bar .

Re: Pick match function in stacked bar 100%

abhijitnalekar — Fri, 10 Dec 2021 09:56:09 GMT

You can create a master dimension for delay field and set the colors for each value in the property like below