9 Replies Latest reply: Oct 21, 2015 10:21 AM by Xavier HEMELAAR

# Set color to a Measure

Hi Qlik Community,

I'm trying to find a way to set a color to my measures. I know how to set a color to a dimension, but here I'm working on a barchart that has several measures and the colors are automaticaly set by Qlik Sense.

Lets say I have a dimension (x-axis) that is weeks. Then I add several measures (y-axis) like:

Sum(if([week import]<=[WEEK NOUVEL IMPORT],RtD))

Sum(RtD)

Sum(if([week import]>[WEEK NOUVEL IMPORT],[RTD FC (BOTTOM-UP)]))

How can I tell Qlik Sense to give a specific color to my 3 measures?

Best regards.

Xavier

• ###### Re: Set color to a Measure

Same question, different custom colors by measure

• ###### Re: Set color to a Measure

Hi Xavier,

I'm somewhat confused as I don't believe you can have more than one measure in a bar chart. You can have more than one in a line or combo chart however so perhaps that is what you mean?

If I understand your question correctly then, you want to assign each measure a specific color in a chart that supports multiple measures, such as a line chart. At the moment I don't believe this can be done.

Regards,

Rod

• ###### Re: Set color to a Measure

Hi Rod,

Yes it's possible to add several measures to a bar chart if you are using only 1 dimension. I found a way to set color for a measure directly on the Qlik Community. No very easy to use but it works. (doesn't work for combochart)

Qlik Sense: How to set custom colors by measure in a bar chart

Enjoy!

Xavier

• ###### Re: Set color to a Measure

Hi Xavier,

My apologies, I was confused as to what you were asking, you can indeed have many measures on a bar chart and the solution you have linked to is one I am aware of. Not sure what I was thinking now but glad you got it worked out.

Cheers,

Rod

• ###### Re: Set color to a Measure

Hi Xavier

You approach with value list to set colors to your mesures is a very good approach : i need to test it.

You may also find very interesting to use the new variable interface and take advantage of it, to set your colors in your chart

Qlik Sense - Variables Interface (video)

Hope it helps

Bruno

• ###### Re: Set color to a Measure

Hi Bruno,

How can the new variable option help to define color for measure?

Best regards.

Xavier

• ###### Re: Set color to a Measure

Hi

Have a look to this link

https://community.qlik.com/docs/DOC-9257

You will also get an example app to download to see how it works.

for each mesure add a variable with you mesure and using colormix function

name your variable as vColorMesure1 and so on

So when using the mesure add the named of the variable in the color mesure panel

Bruno

• ###### Re: Set color to a Measure

Hi Bruno,

I took a look at your link and I tried a few things. But I didn't manage to do what I'm trying to achieve. Still this will be helpfull for other topics I'm dealing with.

I attached an app, that has one chart. It's a combo charts with 3 measures. The colors are set by the system, how can I put the colors I need using variable or other method?