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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
JSF
Contributor II
Contributor II

Mass List Filter Option

 
I am converting some Power BI dashboards over to qlik and I need to replicate a function that will allow me to paste a list of contract numbers for the table to be filtered on. For example, I may have a table with 50k+ rows but only want it filtered for 20 different contract numbers. Is there a way in Qlik Sense to be able to paste my list of contract numbers for the table to be filtered on? By the way, my table will be much longer than 50k rows and I will be filtering on 100+ contract numbers, that was just an example. Thanks!
Labels (3)
2 Replies
Chanty4u
MVP
MVP

You can try this 

("Contract1"|"Contract2"|"Contract3"|...)

 

Ben_P
Creator II
Creator II

Qlik is pretty good at accepting multiple values in a paste. For example if you have a list of 10 values in consecutive cells in a column in Excel, you can generally just highlight the cells, copy, then open the Qlik filter and paste. You just have to make sure you press enter after pasting rather than clicking the tick icon. One other thing to watch out for is if any of your values contain spaces - if they do, then those values will need to be enclosed in " marks. Not sure if this works from PowerBI -> Qlik, but it definitely works from Excel.