using OR in NPrinting filters

ali_hijazi — Mon, 08 Feb 2021 09:06:50 GMT

Hello
I got a report to create in NPrinting (september 2020 version)
I want to show the tickets whose status is not in (solved, resolved,cancelled) or creation_date is in currrent quarter
How can I accomplish this condition or filter in NPRINTING
in Qlik sense I can accomplish this using set analysis
by creating a calculated dimension:
aggr(only({<case_status-={"solved","resolved","cancelled"> + <creation_quarter={"=$(=quartername(Today())))"} case_id),case_id)
kindly advise

Re: using OR in NPrinting filters

Lech_Miszkiewicz — Mon, 08 Feb 2021 10:49:34 GMT

Those kind of filters can be achieved using advanced search and it is not really NPrinitng question but just Qlik Sense "Advanced Search" property question...

I dont know your data model so I am just assuming things based on information you have provided. You can test this by applying it as advanced search on the field in Qlik Sense directly to see if it returns correct values...

so assuming that the field you want to filter is called "case_id", I would create filter on this field with "Advanced Search option and value like:

=Count(Distinct {<case_status-={"solved","resolved","cancelled"> + <creation_quarter={"=$(=quartername(Today())))"} case_id) > 0

more about advanced search filters here:

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

and obviously there is more info on https://help.qlik.com

hope this helps

topic using OR in NPrinting filters in Qlik NPrinting

using OR in NPrinting filters

Re: using OR in NPrinting filters