Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master
Partner - Master

using OR in NPrinting filters

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

I can walk on water when it freezes
Labels (2)
1 Reply
Lech_Miszkiewicz

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

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.