Discussion Board for collaboration on Qlik NPrinting.
I am stuck with the filtering functionality at nprinting 17.
What I need to do is to send the last 30 days from a report based on a date field.
I have used evaluate value to do that, but is not working and it is sending all dates.
Help is appreciated.
Go to Solution.
=date(today()-30) is not a range. it is just the date 30 day's before today
i prefer to flag the Dates in load Skript of your app- like if(REPORT_DATE >=date(today()-30),1,0) as ShowLast30Days, then you can use this as Filter in Nprinting.
the result of today()-30 is a number not a date, try "=date(today()-30)"
Thanks, Aaron but did not work.
That made the work Aaron,
unfortunately I do not have NP17 to test it but in 16 this works:
"=REPORT_DATE >= Date(Today()-30)"
The evaluate checkbox needs to be empty for it to work.
Simple ">= Date(Today()-30)" might work in 17 though.