Filtering on a list in NPrinting

[stella_m]

Hello everyone,

I have come across a problem when using filters on NPrinting...

I have a very big list of [Product ID] and they don't have any link between them, for example :

[Product ID] = 1

[Product ID] = 5

[Product ID] =7

....

(but there are 178 of them)

I need to do a report that shows me our sales on these 178 product IDs but if I do the normal filter it's going to take a lot of time :

I have been trying to do this with the 'advanced search' option but nothing I do seems to work.

I have tried using the match() and wildmatch() functions but they only work when you have one ID that you are looking for. They don't filter on the ID itself but on the position that they are in...

Has anyone come across a problem like this one ? how did you overcome it ? 

Thank you all for your help

[Lech_Miszkiewicz · Accepted solution]

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

[stella_m]

Hi lech_miszkiewicz !

Thank you very much for your help ! 

Unfortunatly, I had seen the import filter option on internet but I don't have the rights on NPrinting to use it.

As for the second option, it works perfect  ! The other solution I had found in the meantime was : 

= [Product ID] = '1' or [Product ID] = '5' or [Product ID] = '7'  ...

Cheers ! 🙂 

[Lech_Miszkiewicz]

Hi @stella_m 

yes - advanced search may have many working options. One you have found is working but has probably the longest syntax 🙂

one of other simple options would be:

=Match([Product ID] ,'1','2','3'.......)>0