Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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! 🙂