topic Re: conditional background colour expression - if statement in QlikView

conditional background colour expression - if statement

gilldilpreet — Thu, 03 Oct 2019 08:40:15 GMT

I am trying to add a conditional expression to a field in my straight table so that the background colour will be orange if the Status = Leaver.

I am attached my progress with this so far...

Any help would be much appreciated!

Thanks

Dilpreet

asinha1991 — Thu, 03 Oct 2019 08:50:50 GMT

what is the exact issue you are facing? you expression seems correct..

it will apply only to one cell. if you it for all cells, add same condition in all fields

Frank_Hartmann — Thu, 03 Oct 2019 08:52:45 GMT

Maybe this:

if(aggr([Status],Level)='Leaver',RGB(235,100,30),White())

gilldilpreet — Thu, 03 Oct 2019 08:53:37 GMT

It doesn't seem to be working?

Yes, I only want the colour to change in one cell.

Thanks

Dilpreet

asinha1991 — Thu, 03 Oct 2019 08:56:12 GMT

the only reason I can think of is, Leaver either has different case or has additional spaces, maybe apply trim

gilldilpreet — Thu, 03 Oct 2019 08:56:35 GMT

I have solved it - the transparency was 100%!