Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishna4bo
Contributor

Expression for custom color for measures

Hi All,

I created Two  measures and one Expression for Color.


My Expression For conditional color: It is giving same color for 2 bars.

If($(=Round(Avg([Unavailability%])))<>0,RGB(0,0,255),

if($(=Round(Avg([Overall Availability%])))>=98,RGB(0,128,0),

If($(=Round(Avg([Overall Availability%])))>=97,RGB(255,255,0),RGB(255,0,0))))

Pls help me.

Thanks,

Krishna