Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Colour 2 Measures on a bar graph by expression and not values

Afternoon all,

I have searched for a good hour on the solution and only found answers where they are colouring a bar graph based on values.

I have a bar graph. It has 1x Dimension - Regions (North,South,East, West) and 2x Measures Red & Amber

Red expression = COUNT({<THREE_MNTHUTIL={"<=10"}>}THREE_MNTHUTIL)

Amber expression = COUNT({<THREE_MNTHUTIL={">=11 <=20"}>} THREE_MNTHUTIL)

On my graph I'm just wanting the Red value whatever it is to colour it RED and Amber to colour it Orange.

I have tried created 2x Master Measures and putting the expression inside this however when I drag onto graph its still not working.

Thanks in advance 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Discovered how to achieve this.

  1. Go to your graph and select the measure you want to add a colour to.
  2. Where Master Item is, it will say “Add New” – Click this
  3. Select Colour you want under “Measure Colour” and press Create.
  4. Repeat this for each measure.
  5. Now go to Appearance then Colours & Legend.
  6. Change Colours off Auto
  7. Change Single colour to Multicoloured.
  8. Change “Use library tools” to Measure.

View solution in original post

3 Replies
Highlighted
Contributor II
Contributor II

Hello,

For most of the things you are already on the right path. 

1. Create a master measure for COUNT({<THREE_MNTHUTIL={"<=10"}>}THREE_MNTHUTIL) and set the measure color to Red.

2. Create a master measure for COUNT({<THREE_MNTHUTIL={">=11 <=20"}>} THREE_MNTHUTIL)

 and set the measure color to Amber.

3. Add these master measures to the needed bar chart.

4. Once your graph is ready as expected go to Appearance > Colors > and turn on the library colors. 

 

This will give you the expected graph behavior.

Regards,

Sourabh

Highlighted
Contributor III
Contributor III

I have carried out the above and please see attached for output. Still not working. 😞

Highlighted
Contributor III
Contributor III

Discovered how to achieve this.

  1. Go to your graph and select the measure you want to add a colour to.
  2. Where Master Item is, it will say “Add New” – Click this
  3. Select Colour you want under “Measure Colour” and press Create.
  4. Repeat this for each measure.
  5. Now go to Appearance then Colours & Legend.
  6. Change Colours off Auto
  7. Change Single colour to Multicoloured.
  8. Change “Use library tools” to Measure.

View solution in original post