Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
vsap2000
Creator
Creator

How to pass Multiple values in search filter using Qlik Sense

Hi,

I am trying to pass multiple values in search filter for product field, I tried using for eg: (Ringbell|Light Spring|Small Bulb|Motor) but as soon as I add '|' after Ringbell, it says no matches for your search. How could I accomplish this requirement, from user who runs report monthly with same list of product(142 products) and want to bookmark it.

Is there any other way to achieve please let me know.

Thanks in advance.

-vsap

Labels (1)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi there

I found this trick by mistake while busy with something else...but you can put the values underneath each other in something like Excel, select and copy cells with values and then just paste it into the search section and press enter. Works like a charm.

Regards,

Mauritz

PS. I think the character limit is something like 255 before the September 2019 release and after the release it is 5000. 

View solution in original post

6 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi there

I found this trick by mistake while busy with something else...but you can put the values underneath each other in something like Excel, select and copy cells with values and then just paste it into the search section and press enter. Works like a charm.

Regards,

Mauritz

PS. I think the character limit is something like 255 before the September 2019 release and after the release it is 5000. 

JGMDataAnalysis
Creator III
Creator III

Nice trick.

To achieve exact matches it is necessary to enclose the values ​​in parentheses.

Result without adding parentheses:

QlikCommunityTrick.PNG

QlikCommunityTrick_01.PNG

 

Result adding parentheses:

QlikCommunityTrick_02.PNG

QlikCommunityTrick_03.PNG

vsap2000
Creator
Creator
Author

Thanks for reply, but it didn't work.

vsap2000
Creator
Creator
Author

It worked, thanks! And you are right it takes upto 255 characters, is any way I can bring more than 255 characters as I have to filter more than 255 characters?

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi

I cannot think of a way other than upgrading to the newest release which will allow you to do it. According to the release notes:

Increased Search Limit on Filter Panes

The limit of search values on a filter pane has been increased to 5,000 characters, allowing more values to be selected in bulk. Previously, search values on a filter pane had a limit of 255 characters, which prevented users from copying and pasting a large number of distinct values to apply selections on a field.

Regards,

Mauritz

AustinP
Contributor
Contributor

The parentheses do not work for me but following the same process using single quotes around the ID like: 'A000' 'A001' 'A002' does work for me.