Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rcarlso6
New Contributor

Paste list of specific values in filter pane

Hi Team - I'm using Qlik Sense to analyze sales data containing a huge amount of invoices.  I have a need to pare this list down to a specific list of invoices... The problem I'm having is that the specific list of invoices is very large in and of itself.  About 10k.  Is there a way for me to paste in the list of invoice numbers perhaps using a filter pane expression?  I've tried "=match([Invoice Number], invoice1, invoice2, etc) but there is only room for about 800 invoices on 1 line and I can't figure out the syntax to carry the list of invoices down over multiple lines of code.  I'm a business user, not a developer.   Thanks!

2 Replies

Re: Paste list of specific values in filter pane

May be Search this way 'Invloice*'

rcarlso6
New Contributor

Re: Paste list of specific values in filter pane

I'm sorry, I'm not following... can you provide some more detail?