Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional RGB symbol status change

Hi,

I am new to Qlik and I have been trying to figure out how to make condition status symbol based on the comparisons of two set expression.

For instance, in the image below I have 2 numerical figures (10&15) I want a green light when the 10 is lower than 15 and a red light when the 15 is greater than 10 in all cases when the filters change.

Is that possible?

Any help would be greatly appreciated

Thanks

2 Replies
Anil_Babu_Samineni

You can change it as. Make sure to change from text to image for representation

If(Expression < 15, 'Green Color', If(Expression > 10, 'Red Color'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

hi,

thanks for your reply - but the 15 and 10 are not static figures - they change depending on the selection of the filter so I would need the status change to be dynamic

Does that make sense?

and if possible - step by step instructions please - i am very new to qlik

Thanks