Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Color expression for different measures

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

1 Solution

Accepted Solutions
homersimpson
Contributor II

Re: Color expression for different measures

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.

2017-07-29_23h59_35.jpg

4 Replies
OmarBenSalem
Esteemed Contributor

Re: Color expression for different measures

Maybe like this?

OmarBenSalem
Esteemed Contributor

Re: Color expression for different measures

Capture.PNG

homersimpson
Contributor II

Re: Color expression for different measures

For example i want to show

Cola: #204F79

Sprite: #4F9BD9

Fanta: #BAD8F4

homersimpson
Contributor II

Re: Color expression for different measures

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.

2017-07-29_23h59_35.jpg

Community Browser