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!
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.
