Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @stella_m
There are 2 options:
1 - you can use excel import to import that filter to NPrinting: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Import-Use...
Under this link you have all required information as well as the Sample files which will give you idea on how to impement it. Also note that your ID may be numberical /integer value in Qlik data model and in such cace you would need to use "numerical value" as a filtering option as described here: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Static-dynam... .
That would be preferable method as using Advanced search as powerful as it is can cause issues if not used properly (Advanced search is a result of search within the selection state so that has to be taken into account)
2 - Advanced search - yes, you can use advanced search option. One I really like is with follwing syntax:
=Count(Distinct {1<[Product ID]={1,2,3...}>}[Product ID])>0
obviously you can test if that filter works by creating table in Qlik Sense with [Product ID] as dimension and "Count(Distinct {1<[Product ID]={1,2,3...}>}[Product ID])" as measure where {1,2,3...} are all IDs you want to include. Note that I didn't use quotes as I assume your [Product ID] is an integer but if it is not you may need to use: {'1','2','3' etc......}. You can also check if your filter will work directly on the field by putting search expression into search box on field as shown below:
Let us know how you go.
cheers