Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
AmCh
Creator
Creator

Coditionned formatting

Hi all,

I want to set a colour for the background to my text object based on value of a variable. How can I do it because I didn't get it with many conditions in If statement.

variable=x

x>50 red

x<25 red

25<x<30 orange

45<x<50 orange

30<x<45 green

Any help please?

 

Thanks in advance

 

 

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Nest the if statements:

If( x < 25, Red(), if( x <30, rgb(255,128,0), if( x < 45, Green(), if( x < 50, rgb(255,128,0), Red() ))))


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Nest the if statements:

If( x < 25, Red(), if( x <30, rgb(255,128,0), if( x < 45, Green(), if( x < 50, rgb(255,128,0), Red() ))))


talk is cheap, supply exceeds demand