Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression for custom color for measures

I am new to Qliksense, I created one Stacked Bar chart in the Qlik sense. I got requirement to use custom colors on measure. can you help me in the expression logic to get the color. Below is the expression I tried but by default it is considering else statement color.

If (Value = 'Yes',Green(),Red())

I have measure value with Yes and No values. I am displaying Count of Yes and No in the bar chart. I need color expression for this.

Thanks in advance.

Regards,

Sateesh

13 Replies
OmarBenSalem
Partner - Champion II
Partner - Champion II

You have to be using Qlik Sense 3.2 (if not, please upgrade)to be able to affect color to master measures:

Below, I'll be creating 2 master measures: sum("car sales") and sum("commercial vehicle sales"):

Capture.PNG

Capture.PNG

Then, I will create a bar chart and use my 2 measures:

Capture.PNG

Result : (the colors are red and green as we specified when we created the 2 master measures:)

Capture.PNG

xyz1
Creator III
Creator III

.

OmarBenSalem
Partner - Champion II
Partner - Champion II

Please close the thread by marking the right answer as correct

Vasiliy_Beshentsev
Creator III
Creator III

Hello, maybe you can help me here Custom color in combined chart ?