Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mromrod22
Partner - Contributor III
Partner - Contributor III

Force color according of value

Hi,

Is possible, some path of force a color according the value of field? Explain me:

I have a composed bar char create with two small chars togethers, but the colors are distinct in legend (same legends, diferent color). One mini-char show data of 3 values, and the other, show data for 2 values.

Bar Char 1:

  • A - Color blue
  • B - Color red
  • C - Color green

Bar Char 2:

  • A- Color blue
  • C- Color red

I want force colors so that each value have a defined color.

Any idea?

Thanks.

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Against the expression click on the '+' sign to expand it and reveal formatting options

Double click on Background Expression and add expression as

=Pick(Wildmatch(Bar,'A','B','C'),blue(),red(),green())

if you have separate expression for each bar then add expressions to each of them separately

for example for Bar A background expression = blue(); Bar AB background expression = red();Bar C background expression = green()

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Against the expression click on the '+' sign to expand it and reveal formatting options

Double click on Background Expression and add expression as

=Pick(Wildmatch(Bar,'A','B','C'),blue(),red(),green())

if you have separate expression for each bar then add expressions to each of them separately

for example for Bar A background expression = blue(); Bar AB background expression = red();Bar C background expression = green()

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
mromrod22
Partner - Contributor III
Partner - Contributor III
Author

Perfect brother, success! Very thanks.