topic Re: hide unmatched fields in QlikView

hide unmatched fields

Wed, 22 Jan 2014 04:32:12 GMT

hi,

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

Re: hide unmatched fields

senpradip007 — Wed, 22 Jan 2014 04:43:29 GMT

Hi.

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

Regards.

Re: hide unmatched fields

Anonymous — Wed, 22 Jan 2014 04:44:51 GMT

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.

Re: hide unmatched fields

Wed, 22 Jan 2014 05:25:30 GMT

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

Re: hide unmatched fields

Wed, 22 Jan 2014 05:33:46 GMT

hi,

For overriding default color, you can use extension.

Follow this link for details

Document Extension to override green selection color

Re: hide unmatched fields

Sokkorn — Wed, 22 Jan 2014 06:27:34 GMT

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

Re: hide unmatched fields

jagan — Wed, 22 Jan 2014 06:43:05 GMT

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.

Re: hide unmatched fields

Wed, 22 Jan 2014 06:54:10 GMT

Hi,

Pls find attached Qvw. Hope that will work.

Re: hide unmatched fields

Wed, 22 Jan 2014 06:55:28 GMT

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

Re: hide unmatched fields

kamakshisuram — Mon, 18 Aug 2014 15:41:33 GMT

Thanks Saurab. This helped me