Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

Re: Force color according of value

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()

View solution in original post

2 Replies
Highlighted
Champion II
Champion II

Re: Force color according of value

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()

View solution in original post

Highlighted
Partner
Partner

Re: Force color according of value

Perfect brother, success! Very thanks.