topic Re: background color expression in QlikView

background color expression

didierodayo — Thu, 12 Jan 2017 12:46:45 GMT

Hello,

I have this scenario for background color and it is not working atm.

I have 2 tables as attached and they are not linked. I would like to set the color for city on table 1 to green if the city in table 1 is equal to the city in table 2 otherwise red.

at the moment it works fine only when I select the city in table 2 otherwise by default everything is red.

What I need is for the background expression to check table2 and load the appropriate color even without selection.

how could this be written?

Your assistance is appreciated.

Thanks

Didier

Re: background color expression

sunny_talwar — Thu, 12 Jan 2017 12:52:40 GMT

May be this:

If(Avg({<City = p(City1)>} 1) = 1, GREEN(), RED())

Re: background color expression

didierodayo — Thu, 12 Jan 2017 13:02:08 GMT

Thanks a lot Sunny for all your help really appreciate.It worked.

I have one question though, If I didn't want the '1' TO SHOW inside the color is there a way to keep it as pivot table but only have the color showing?

Re: background color expression

sunny_talwar — Thu, 12 Jan 2017 13:03:39 GMT

Use the same expression for your text color