Personalized colors by dimension in a bar chart

[clarachac]

Hello,

I have a bar chart with 2 dimensions (year, product) and 1 measure.
I would like to personalize the color of the bars by product : 

But if I put the color by expression, the legend disappears :

If(REGROUPEMENT='Produit 1',rgb(235,120,0),
If(REGROUPEMENT='Produit 2',rgb(255,205,0),
If(REGROUPEMENT='Produit 3',rgb(0,120,154),
rgb(0,179,136))))

How can I have the right colors AND the legend?

[Clement15]

Hello, by creating a master measure you can choose the color of your dimensions. You then select the color by size, this should meet your expectations.

[clarachac]

I want the color by product, how can I create a master measure of Product knowing it's a dimension, I don't understand.

[Clement15]

This should help you 

Creating a master dimension from a field | Qlik Cloud Help

[MatheusC · Accepted solution]

Hi, @clarachac 

Create a master dimension
1- Master items -> Create new -> create your master dimension here
2 - Edit your master dimension, and then in Value colors define the colors by the dimension values ​​as mentioned As shown in the screenshot below

Regarts, Matheus

[clarachac]

Hello, @MatheusC 

I don't have the 'value colors' option 😞

[Clement15]

The option will be available after creation, you can add the colors in editing

[clarachac]

Ah yess it works! Thank you very much @Clement15 @MatheusC