Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Susan_DS
Partner - Contributor III
Partner - Contributor III

Master Measure Color by Expression

Hi, all,

I have a chart that uses two master measures: one for projected sales, one for actual sales.

I would like the first master measure (projected sales) to show as a single color, and the second master measure (actual sales) to display as red if it's less than 85% of projected sales, green if it's over 90% of projected sales, and yellow if it's in between 85% and 90%.

I've tried using the segment colors option in the master measure for actual sales, and also using no master measure and coloring by expression. However, I haven't found a way to apply a conditional formatting only to ONE of the measures. See the screenshot below for how it's turning out.

Qlik community, how do I apply the conditional color coding to only ONE of the measures?

Susan_DS_0-1599748039003.jpeg

 

Labels (4)
0 Replies