How to create an NPrinting filtre object that selects all values of a field ?

[hudhud_hoda]

Hello,

i need to build a report from a table.
in this table i have a service hierarchy built from 3 fields.
i want to filitre the table in one sheet of the report on all values on the third level of the service hierarchy, which is the department. How can i select all values of the department in the filtre of the object , i have alot of values for this field ?

thanks alot

NPrinting Feb 2024

[Lech_Miszkiewicz]

Super easy

use Advanced search filter and formula. I like to use following syntax which allows me to use {1} full state 

So assuming that I want to select all values from field VehicleID this would be the syntax:

=Count(Distinct {1} VehicleID)>0 (check screenshot below)

If you want to learn more about filters I invite you to read through those:

https://nprintingadventures.com/category/nprinting/filters/

...and also on help site which I assume you have already studied thoroughly as that would be first place to check how to do things in Qlik, right?

https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Static-dynam...

cheers