
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter pane with AND/OR
Hi,
am would like to know if it is possible, to somehow set AND/OR criteria in a filter pane.
For example i have a filter pane for order number and i would like to filter the order numbers beginning with 31 AND 52.
Like 31* AND 52* or something.
Is that possbile with filter pane?
Best regards.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can filter as below
(*3|*5)
Refer this post on search string
https://community.qlik.com/t5/Design/The-Search-String/ba-p/1470548
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is great thank you, can i combine this to with wildcards?
So for example *54 AND *67*?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Additively select first for *54 and for *67* after

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Alright great, but the same with OR is not possible then with wildcards?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you describe how this would look like, best with some examples and your expected results?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For example if i want to filter all order numbers which end with 3 OR 5.
When i filter *3 *5 it doesnt work with using a space.
Example - i have the following numbers:
103
203
104
204
105
205
etc.
and i want to get 103,203,105,205.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can filter as below
(*3|*5)
Refer this post on search string
https://community.qlik.com/t5/Design/The-Search-String/ba-p/1470548
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great that works, thanks a lot to all of you!
