Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
john_henry
Contributor III
Contributor III

Filtering using a list of values

I have a list of values (for example, 100 product numbers) that I copied from Excel and pasted into a search field of a filter in QS.  However, the filter doesn't let me easily select the 100 values that I pasted.  Rather I have to scroll through the filter pane and swipe down with the pointer to select the values.   Why can't I just click the green check box at the top right and select only those that I have pasted?

Also, there could be values that are similar, but not exact, and so I have to scroll through the filter list to select the 100 items.  For example, if I want product # 12345, but there is a value of 123456 in my filter list, then it will "suggest" 123456 in the filter list and I have to go through the values in the filter and cull them out.  This does not work when you have a large list of values you are trying to query and match exactly.

How can a casual user (not a BI developer) query the dataset easily using a predefined list of values?

1 Reply
Wlad_Masi
Former Employee
Former Employee

Hello John,

 

We have a feature request, asking for the ability to set the limit that most fit for your business.
Today we cannot change this limit.

This article has this information "Feature request: increase max limit of characters in filter pane"

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.