Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ktucker8
New Contributor

Copy and Pasting values from Excel into Qlik Sense Filter Pane

Has anyone found way to copy and paste a list of values from Excel and input into a Filter Pane in Qlik Sense?  For example, a list of Invoices.

I've seen input into Input Box in Qlikview.but can't seem to find anything in QlikSense for similar functionality.

4 Replies
bellamae
Valued Contributor

Re: Copy and Pasting values from Excel into Qlik Sense Filter Pane

Why would you not load the list of values as a table in the data model?

ktucker8
New Contributor

Re: Copy and Pasting values from Excel into Qlik Sense Filter Pane

It's for users to be able to filter for their desired invoices.  They have excel lists generated from other areas and need to filter a detail list for 20+ invoices, etc.  They need ability to paste those 20 selections in vs having to type and select all of them.  All company invoices are loaded and need to be accessed so can't limit load

bellamae
Valued Contributor

Re: Copy and Pasting values from Excel into Qlik Sense Filter Pane

Sorry I am not aware of anything that will help you there.

Smaggot
New Contributor

Re: Copy and Pasting values from Excel into Qlik Sense Filter Pane

Hey there, 

 

This is an old post but I was struggling with the same use case, and managed to find an answer so thought I would post it here for future reference. You can search for multiple values by using the pipe character, e.g. if you want to filter for invoice numbers 5, 6 and 22, input "5"|"6"|"22" into the filer pane. 

Community Browser