topic Re: Changing background color based on two different words in QlikView

Changing background color based on two different words

hammermill21 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table that when there is a "Y" under "entrapment" I want the cells to turn yellow and if there is a "Y' under Vandalism I want the cell to turn red. I know if I do this:

if(Entrapment='', white(), yellow())

It will work but how do I add the Vandalism part to this expression?

Thank you!

Re: Changing background color based on two different words

sunny_talwar — Mon, 05 Feb 2018 13:01:31 GMT

May be this

If(Entrapment = 'Y', Yellow(),

If(Vandalism = 'Y', Red(), White()))

Re: Changing background color based on two different words

Anil_Babu_Samineni — Mon, 05 Feb 2018 13:03:08 GMT

Perhaps this?

If(Entrapment='', White(), If(Vandalism='Y', Red(), Yellow()))

Re: Changing background color based on two different words

hammermill21 — Mon, 05 Feb 2018 13:03:10 GMT

Thank you Sunny,

I see what I did wrong when i tried that.

Thank you

Re: Changing background color based on two different words

sunny_talwar — Mon, 05 Feb 2018 13:04:03 GMT

What was it, if you don't mind sharing that

Re: Changing background color based on two different words

hammermill21 — Mon, 05 Feb 2018 13:07:10 GMT

I had it set like this:

if(Entrapment='', white(), yellow())

if(Vandalism='', red(), white()))

I needed to remove the first "White()", an oversight on my part.

Re: Changing background color based on two different words

sunny_talwar — Mon, 05 Feb 2018 13:08:11 GMT

Make sense, thanks for sharing