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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

Multi KPI box add colour by if statement in expression

Hi,

I have the following in a multi kpi box (where there is no colour by expression option)

I require 3 kpi's which is why i am using the multi kpi box and not the standard one

I need to colour the result red if <100 blue when >100

I have no idea if/how i can achieve this. can anyone assist?

Thank you

 

Num(
sum({$<
$(v.Date.IgnoreAll),
[Year] = {"$(=max(Year))"}

>}[GBP_Price])
,'$(v.Format.Int.0dp)') /

Num(
sum({$<
$(v.Date.IgnoreAll),
Month = {'Jan','Feb','Mar'},
[Year] = {"$(=max(Year))"}

>}
([Budget in GBP])),'$(v.Format.Int.0dp)')

*100

 

Labels (1)
0 Replies