hide unmatched fields

[#1]

hi,

please tell me how to hide unmatched rows without getting grey color in list boxes. thanks

[senpradip007]

Hi.

To hide the unmatched rows go to the list box property and check the "Hide Excluded" option. Hope it will help you.

Regards.

P

[Anonymous]

Hi,

     You can use Hide Excluded, but there will be gray color background and i am also not able to find any color field to make it transparent , may be you have to use sort like that only selected one will come first and rest in last.

[#4]

hi, is anyone know how to hide that grey color background?

[#5]

hi,

For overriding default color, you can use extension.

Follow this link for details

Document Extension to override green selection color

[Sokkorn · Accepted solution]

Hi Dushan,

If you want to hide other item beside selected, we need to use expression in List Box. Let try:

Create new list box -> Scroll down to bottom and click on <Expression> -> Use this sample =Aggr(Only(YourField),YourField)

Another method, we can use Table Box and add your field there.

Regards,

Sokkorn

[jagan]

HI,

You want to change the background color or to hide the values?  If you want to change the color, then it is not suggestible because you don't know which is valid and which is Excluded.  If you want to hide then you can use

=Aggr(Only(YourField),YourField)

as Sokkorn suggested.

Regards,

Jagan.

[#8]

Hi,

Pls find attached Qvw. Hope that will work.

[#9]

hi jagan,

I want to hide the unmatched values. when I selected hide excluded, i can achieve what i want but the problem is it s appearing a grey screen after the values. now I got the answer. Thanks

[kamakshisuram]

Thanks Saurab. This helped me