# 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

## 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)
• ### COLOUR BAR GRAPH MEASURE

1 Solution

Accepted Solutions
Highlighted
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.
3 Replies
Highlighted
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

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

Highlighted
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.