Color expression for different measures

[Anonymous]

Hi,

i have this table

tbl_sales:

LOAD * Inline

[Store, Cola, Sprite, Fanta

New York,2407,6262,37526

Chicago,11600,30583,140708

San Francisco,40,100,1159

];

I create a barchart and use Store as dimension.

Cola, Sprite, Fanta as measure

I want to show each measure in a special color. How can i do it?

Next step, if the Store = Chicago the measure colors for this store should be another special colors.

Best regards,

sam

[OmarBenSalem]

Maybe like this?

[OmarBenSalem]

[Anonymous]

For example i want to show

Cola: #204F79

Sprite: #4F9BD9

Fanta: #BAD8F4

[Anonymous · Accepted solution]

I found a solution: Qlik Sense: How to set custom colors by measure in a bar chart and added some code to show "Chicago" bars in another color.