Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtj
Creator II
Creator II

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.

 

Labels (2)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

8 Replies
Mark_Winter
Creator
Creator

Mark_Winter_0-1673524265652.png

 

schmidtj
Creator II
Creator II
Author

That is great thank you, can i combine this to with wildcards?
So for example *54 AND *67*?

Mark_Winter
Creator
Creator

Additively select first for *54 and for *67* after

schmidtj
Creator II
Creator II
Author

Alright great, but the same with OR is not possible then with wildcards?

MarcoWedel

can you describe how this would look like, best with some examples and your expected results?

schmidtj
Creator II
Creator II
Author

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. 

vinieme12
Champion III
Champion III

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

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
schmidtj
Creator II
Creator II
Author

Great that works, thanks a lot to all of you!