topic Re: Nprinting Advanced Search in Qlik NPrinting

Nprinting Advanced Search

ali_hijazi — Wed, 12 Nov 2025 08:13:55 GMT

Hello
I have an Nprinting Report and I want to create a filter
the filter should be defined on a field named BU
I want that BU is any value except BU1 and BU2
kindly advise on how the syntax is under the Advanced search

Re: Nprinting Advanced Search

Lech_Miszkiewicz — Wed, 12 Nov 2025 09:31:47 GMT

=Count(Distinct {<Disease=-{'BU1','BU2'}>} BU)>0

optional you can use "1" to ignore any other filters you apply in that report:

=Count(Distinct {1<Disease=-{'BU1','BU2'}>} BU)>0

cheers

Re: Nprinting Advanced Search

Lech_Miszkiewicz — Wed, 12 Nov 2025 09:32:58 GMT

just to clarify - there can be many other ways of writing this advanced search expression - i just use count(distinct.... syntax as I like to be able to use set analysis in it.

cheers

Re: Nprinting Advanced Search

PrashantSangle — Wed, 12 Nov 2025 09:34:07 GMT

Create new field in dashboard which exclude those field values. & use that in your report.

Regards,

Prashant Sangle

Re: Nprinting Advanced Search

Lech_Miszkiewicz — Wed, 12 Nov 2025 10:29:49 GMT

HI @PrashantSangle

That is not advanced search tip though - This is a valid solution but not appropriate to the question I will argue. Your solution does not require advanced search as you can simply create a flag in load script and use "Value is:" filter.

So bottom line is: for advanced search option use my option or other advanced search expression you like to come up with or if you can access data model and add that new field use value is filter with flag....