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

Announcements
Join us in Bucharest on Sept 18th 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