Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Digital Support
Digital Support

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.