Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Qlik NPrinting

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE

Who Me Too'd this solution

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Lech_Miszkiewicz_0-1753139515396.png

 

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:

 

2025-07-22_09-20-22 (1).gif

 

Let us know how you go.

cheers

 

 

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Who Me Too'd this solution