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: 
Pongsakon_J
Contributor
Contributor

Setting color condition text in box

I have text box with this calculation on below

count( {<[Date] = { "$(='>=' & monthstart(max([Date])) & '<=' & monthend(max([Date])))" }

              , [Status] = -{''Status1, 'Status2', 'Status3', 'Status4'}

              , [Result] = {'On Target'}

>} distinct [Item ID] )

/

count( {<[Date] = { "$(='>=' & monthstart(max([Date])) & '<=' & monthend(max([Date])))" }

              , [Status] = -{''Status1, 'Status2', 'Status3', 'Status4'}

>} distinct [Item ID] )

 

I want the number appear in RED if lower than 0.90 and other in GREEN

How to write the expression

 

Thank you,

Labels (1)
2 Replies
FruzoCrew
Creator
Creator

if(expression < .9, red(), green())

or

if(Column(1) < .9, red() green())

Pongsakon_J
Contributor
Contributor
Author

I already set the expression like you said

but value appeared in code of color not value of calculation