Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Verify the colour code expr

Hi Folks,

can any one help with below Qlik Sense expr..

Below expr geting 0.80 is showing as red, as per below expr it should show green colour..

=If(

(

IF(Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket)>0,

Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket))

/(

IF(Count({<[Type 1 Count]={'1'}>}Ticket)>0,

Count({<[Type 1 Count]={'1'}>}Ticket)

)

)

)

>=0.80,Green(),Red()

)

1 Reply
MVP
MVP

Re: Verify the colour code expr

Actually it is green when the expression is above 0.80. If it is below 0.80, the expression will show 0.80. May be change the order of Green and Red around?

=If(

(

IF(Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket)>0,

Count({<[T1 >= 7days (Start Work ~ OnWatch)]={'0'},[Type 1 Count]={'1'}>}Ticket))

/(

IF(Count({<[Type 1 Count]={'1'}>}Ticket)>0,

Count({<[Type 1 Count]={'1'}>}Ticket)

)

)

)

>=0.80,Red(),Green()

)