NPrinting Filter for Dates

[brandon_d]

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".

[Lech_Miszkiewicz · Accepted solution]

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-...