Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Charlz_1
Contributor II
Contributor II

Change color of dimensions in Qlik

Good day

I need help in changing this dimension into Red for bad and Blue for good color

Charlz_1_0-1662645656859.png

Your help will be much appreciated.

Thanks.

Labels (2)
1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Another approach would be to use Master item measure

 

For example:

 

1. I have the following dataset:

 

2. I have created a bar chart with the following configuration:

 

  1. Dimension: Data
  2. Measure 1: Count({<Status={'GOOD'}>}Status)
  3. Measure 2: Count({<Status={'BAD'}>}Status)

Outcome:

 

3. Now I have created the measures in Master item measure:

 

4. Created a new Bar chart with those Master item measures as my measures and the outcome is:

 

As you can see the BAD is represented with red and GOOD is represented with blue as you specified.

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

3 Replies
SchalkF
Contributor III
Contributor III

Hi,

In die chart properties, under Appearance->Colors and legend, switch off the Auto Colors, then click on single color and select 'By Expression'.

Enter the expression as follows:

If(Measure = Good, blue(), red())

Kind regards

MatheusC
Specialist
Specialist

Olá, @Charlz_1 

Você pode fazer por expressão 

if(dimensão='Boa','Blue','RED')

MatheusC_0-1662647143592.png

Caso tenho ajudado, marcar como solução e deixar um Like

Muito Obrigado!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Another approach would be to use Master item measure

 

For example:

 

1. I have the following dataset:

 

2. I have created a bar chart with the following configuration:

 

  1. Dimension: Data
  2. Measure 1: Count({<Status={'GOOD'}>}Status)
  3. Measure 2: Count({<Status={'BAD'}>}Status)

Outcome:

 

3. Now I have created the measures in Master item measure:

 

4. Created a new Bar chart with those Master item measures as my measures and the outcome is:

 

As you can see the BAD is represented with red and GOOD is represented with blue as you specified.

Help users find answers! Don't forget to mark a solution that worked for you! 🙂