6 Replies Latest reply: Aug 7, 2018 8:47 AM by Sibin Jacob.C C

# Assigning Specific Colors to Measures

Hello qlik friends,

I am having an issue with assigning colors to measures within Qlik sense. Important note: I have no editing access to the master Item colors for measures, and the measures are not a field but a long formula.

In order to get around it I assume I would need to use Qlik expressions, how would I go about assigning this graph's colors (attached is an example of the formula that is a measure).

thanks all!

Ken

• ###### Re: Assigning Specific Colors to Measures

You can calculate a color number out of the expected possible value range of the expression you have.

For instance if an expression yields typically values between 5000 and 10000 you can adapt this to colors between 1 and 5. That would be simply to divide by 1000 and subtract 4. This would be a static way of doing it that might work well for a lot of cases. You could to it dynamically by finding the max value of the expression over the range of dimension values you will use either out of context of the chart which would be semi-dynamic or directly in the context of the chart completely dynamic. The complexity to achieve this increase with the level of dynamism...

So for the simple static case I mentioned above you would have:

Color( Sum(....... ) / 1000 - 4 )

as a color expression.

• ###### Re: Assigning Specific Colors to Measures

thanks for the reply. I think my ranges are too big for this idea, but I appreciate the reply, I will look into it!

• ###### Re: Assigning Specific Colors to Measures

Please go through the below link, it may be helpful.

Qlik Sense Color Range Theme Approach

The approach aims to use an expression that doesn't need to be rewritten each time the measure changes and can be copied across different objects without changes.

• ###### Re: Assigning Specific Colors to Measures

This does not appear to be a public location. sibin.jacob can you either ask the moderator to open it up or make a copy of the content for the rest of us?

Thanks

• ###### Re: Assigning Specific Colors to Measures

I am not able to see that document now.

The same logic applied in another document and sample file also available in the below link.

Color Themes with ColorMix.qvf

• ###### Re: Assigning Specific Colors to Measures

I am seeing the same error.