topic Re: How do I hide values in a list box? in QlikView

How do I hide values in a list box?

Anonymous — Wed, 11 Jun 2014 10:35:00 GMT

I would like to hide values in a list box. For example, I have a list box with values - red, blue, yellow, green, purple, I want to hide the value green from appearing in the list box. Is this possible?

Thanks

Greg

Re: How do I hide values in a list box?

senpradip007 — Wed, 11 Jun 2014 10:40:39 GMT

Try like

If(Value <> 'Green', Value)

If(not WildMatch(Value , 'Green'),Value )

Re: How do I hide values in a list box?

jsingh71 — Wed, 11 Jun 2014 10:52:19 GMT

Hi Greg,

You will writeexpression in list box like

if(<FieldName> <> 'red', <FieldName>)

Find Example in attachment.

--Jai

Re: How do I hide values in a list box?

Anonymous — Wed, 11 Jun 2014 11:19:49 GMT

Thanks Jai

How do I hide more than one colour?

Re: How do I hide values in a list box?

jsingh71 — Wed, 11 Jun 2014 11:23:43 GMT

then you need to use match or wildmatch function.

--Jai

Re: How do I hide values in a list box?

Anonymous — Wed, 11 Jun 2014 11:54:29 GMT

Thanks Jai

Would you be able to show me an example of the match or wildcard function please?

Thanks very much.

Greg

Re: Re: How do I hide values in a list box?

jsingh71 — Wed, 11 Jun 2014 12:11:26 GMT

Find attachment.

--Jai

Re: How do I hide values in a list box?

Anonymous — Wed, 11 Jun 2014 12:27:28 GMT

Very grateful. Thanks very much Jai.

Greg