Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks but unfortunately that didn't work.
This should be very simple. Can you post a sample QVW?
-Rob
Attached. Thanks Rob.
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
Very grateful Rob. Thanks
Greg