topic Re: How to filter the data values in a list box? in QlikView

How to filter the data values in a list box?

rabbani_sk — Fri, 05 Jul 2013 14:43:40 GMT

Hi all, my query is i need to filter some of the data values from a list box.

for example , i hav a field ,

Product code

A xx

Byy

D xx

E xx

So, i need to filter only the data values which consists of 'XX' eg.(A xx, D xx, E xx) , do you any idea , which function to use to filter the data value..?

Re: How to filter the data values in a list box?

Gysbert_Wassenaar — Fri, 05 Jul 2013 14:47:19 GMT

Type *xx in the search box of the listbox. If you want the listbox to never show the other values then use an expression instead of the field name for the listbox: =if(wildmatch([Product code],'*xx'), [Product code]).

edit: try this =if(wildmatch([Product code],'*xx'),null(),[Product code])

Re: How to filter the data values in a list box?

rabbani_sk — Fri, 05 Jul 2013 17:51:54 GMT

Hi,

Thanks for your reply Gysbert , but my question is not to show the product code with 'XX',

Re: How to filter the data values in a list box?

johnca — Sat, 06 Jul 2013 04:32:28 GMT

Try this...

=If(WildMatch([Product Code],'*xx'),Null(),[Product Code])

Note the close parens after the '*xx'.

--john

Re: How to filter the data values in a list box?

rabbani_sk — Sat, 06 Jul 2013 09:16:40 GMT

Thank you gysbert

Re: How to filter the data values in a list box?

rabbani_sk — Sat, 06 Jul 2013 09:17:29 GMT

Hi john,

its working,

Thanks for your reply

Re: How to filter the data values in a list box?

johnca — Sat, 06 Jul 2013 22:02:21 GMT

Gysbert deserves some credit too. All I did was find the syntax error in his solution.

John

Re: How to filter the data values in a list box?

paulyeo11 — Sun, 07 Jul 2013 01:28:13 GMT

hi john

i unable to find any diff between yr and gysbert. it is wild match , the w and m need big cap ?

Re: How to filter the data values in a list box?

johnca — Mon, 08 Jul 2013 02:24:05 GMT

Gysbert edited his initial response, and it is now correct too. His initial solution was correct except he forgot a close parenthesis. I saw that and added it. I capitalize words in functions to better see them, that's all. Both are identical in effect and either solution works the same.

Re: How to filter the data values in a list box?

Tue, 01 Oct 2013 11:53:30 GMT

Nice one guys.. Helpful