Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Filtering Multiple Values - Advanced Search

Hello QV community,

I would really appreciate some help using advanced search (or a useful alternative).

I have a list of contact ident numbers 1A - 100F, but I would like to filter 1A, 6B, 9F, 10C and another 15 numbers, is there a way of seaching them or adding them to an expression on a straight table. I would like to keep going back to these sets of numbers after checking a different search. So I was thinking of an advanced Search but I am not sure how it works.

So the idea is I can search for 20/30 number sets and copy the script into note pad for later use.

Please let me know if you would like a better explaination.

Thank you in advance

Mark

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Filtering Multiple Values - Advanced Search

Have you tried using bookmarks? If that doesn't work for you, have a look at the attached qvw (created by rebeccad). It allows you to enter a list of values in an input box and use the list to select the values.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: Filtering Multiple Values - Advanced Search

Have you tried using bookmarks? If that doesn't work for you, have a look at the attached qvw (created by rebeccad). It allows you to enter a list of values in an input box and use the list to select the values.


talk is cheap, supply exceeds demand
Not applicable

Re: Filtering Multiple Values - Advanced Search

Hello Gysbert,

The Attached Qlikview did the trick. I can now paste a bunch of company numbers in the box and get the results I need.

Thanks

Mark

Not applicable

Re: Filtering Multiple Values - Advanced Search

I'm new to qlikview, but I will use this one later on .

Thanks in advance!

Thomas

Kind regards,