Pick match function in stacked bar 100%

[judikael]

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 .

[abhijitnalekar · Accepted solution]

Hi @judikael ,

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