Background Color on Selected Cell in a Table Box

[pandreozzi]

Sorry for the simple question here but I cannot seem to find the answer. I want to have the background color change on a selected cell and have that cascade to other sheets with associated records. Can anyone assist.

Thanks, Paul

[pandreozzi]

Thanks Jean I will look at this as a possible solution.

Paul

[pandreozzi]

Ok. here is the answer. Nested "if" statements

=if(SITE_STATUS = 'Active', RGB(49,247,38),if(SITE_STATUS = 'Inactive',RGB(240,0,0),White()))

this allows for the selection of a table box item where the text "Active" changes the background cell color to a variation of "Green" and where the text "Inactive" changes the background color to a variation of "Red"

To do this select

Control G to access the grid and right click on the table box item and select custom cell format. From there select background color and under base color select calculated. paste the expression above into the top box and save it. Below are the results>

I cannot display confidential information so sorry you cannot see the other 3 cells but they also represent correctly.

When I clear the table box all returns to white.

[tajmohamed30]

it's good that you found your answer.

There is an option in qlikview, if you want to share your application which has confidential information you can scramble your data and post to anyone and while returning back your application you can reload with original data.

you can do it by document properties, scrambling tab and select the fields to scramble.

[pandreozzi]

Thanks Taj. I will consider this for the next posting if needed. Appreciate your time