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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sharad02
Contributor II
Contributor II

Set analysis for colours for replacing "If"

Can anyone suggest some set analysis that can replace" if  "  for following  Expression

 

 

if(2 * [ACT] > [ACT]
,if([ACT] >= 0.8
,Green()
,if([ACT] >= 0.5
,RGB(255,128,0)
,Red()))
,RGB(200,200,200))
)

 

 

Labels (4)
1 Reply
vinieme12
Champion III
Champion III

for this particular case, you need to use an If() block

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.