Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brandon_d
Contributor III
Contributor III

NPrinting Filter for Dates

I am trying to add a filter within NPrinting that excludes all dates prior to June 1, 2018 from my report. What expression can I use to accomplish this? The field that I will be filtering down on is "Appt Date".

Labels (4)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

At the moment i write this reply you cannot achieve this directly in NPrinting filter!

instead in Qlik model you need to create extra flag field which will flag all “true” records for your condition: like

if([Appt Sate]>=‘01/06/2017’, 1,0) as flag

then in Nprinting filters you can use:

flag, numerical value is: 1

more about this here

https://nprintingadventures.wordpress.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-...

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.

View solution in original post

1 Reply
Lech_Miszkiewicz

At the moment i write this reply you cannot achieve this directly in NPrinting filter!

instead in Qlik model you need to create extra flag field which will flag all “true” records for your condition: like

if([Appt Sate]>=‘01/06/2017’, 1,0) as flag

then in Nprinting filters you can use:

flag, numerical value is: 1

more about this here

https://nprintingadventures.wordpress.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-...

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.