Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

KenLE.PNG

6 Replies
petter
Partner - Champion III
Partner - Champion III

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.

Anonymous
Not applicable
Author

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

sibin_jacob
Creator III
Creator III

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.

SteveNewman
Employee
Employee

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

Anonymous
Not applicable
Author

I am seeing the same error.

sibin_jacob
Creator III
Creator III

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