Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
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.