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.
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
That is great thank you, can i combine this to with wildcards?
So for example *54 AND *67*?
Additively select first for *54 and for *67* after
Alright great, but the same with OR is not possible then with wildcards?
can you describe how this would look like, best with some examples and your expected results?
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.
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
Great that works, thanks a lot to all of you!