Highlight background colour of selection in table

[Anonymous]

Is it possible to highlight the background colour of a selection in the following table whilst still showing all the other selections in the table.

I can highlight the selection using the following background colour expression - =if(GetFieldSelections(institution) = institution, yellow())

However, when I make a selection, all the other institutions disappear from the table. 

I would like to show all values but highlight the selection.  Can this be done?

Thanks

Greg

[Anonymous]

Thanks but unfortunately that didn't work.

[rwunderlich]

This should be very simple. Can you post a sample QVW?

-Rob

[Anonymous]

Attached.  Thanks Rob.

[rwunderlich · Accepted solution]

Here you go attached. I added

shefcint=,

to the Set Analysis to ignore the Institution field.

Your background color expression only worked if one Institution was selected. I modified it so it would work for multiple Institutions.

=if(count(DISTINCT TOTAL shefcint) <  count({<shefcint=>}DISTINCT TOTAL shefcint)

AND

shefcint = shefcint, RGB(0,255,0))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Very grateful Rob.  Thanks

Greg