topic Re: Conditional RGB symbol status change in QlikView

Conditional RGB symbol status change

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional RGB symbol status change

Anil_Babu_Samineni — Mon, 19 Jun 2017 13:16:16 GMT

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'))

Re: Conditional RGB symbol status change

Mon, 19 Jun 2017 13:19:33 GMT

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