topic Copy and Pasting values from Excel into Qlik Sense Filter Pane in App Development

Copy and Pasting values from Excel into Qlik Sense Filter Pane

ktucker8 — Wed, 26 Apr 2017 18:23:36 GMT

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.

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

Anonymous — Wed, 26 Apr 2017 19:25:59 GMT

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

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

ktucker8 — Wed, 26 Apr 2017 20:45:41 GMT

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

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

Anonymous — Wed, 26 Apr 2017 21:53:22 GMT

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

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

Smaggot — Wed, 21 Nov 2018 06:56:14 GMT

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.

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

Antz714 — Fri, 22 Feb 2019 20:23:28 GMT

I know this works in Qlikview but when I tried this in Qlik Sense and it does not work for me.

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

hannessch — Fri, 08 Nov 2019 09:04:09 GMT

Hi,

I struggled with the same Problem and can provide a solution.
The key point was to separate your values with spaces.
For example: "Invoice1 Invoice2 Invoice3" or use any separator between the spaces like "Invoice1 , Invoice2 , Invoice3" .

You can paste this list in the Filterpane and easily select them via select possible or select all function.

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

naamah — Mon, 08 May 2023 07:46:49 GMT

Hi, i'm searching for a solution in qlik sense. I know ther e is a limitation of 5000 characters, therefore if you have a longer list it won't work.