topic Re: Date filters in nPrinting 17 in Qlik NPrinting

Date filters in nPrinting 17

Wed, 25 Sep 2019 18:40:54 GMT

Hi,

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.

Thanks

Re: Date filters in nPrinting 17

aaron_ppmc — Wed, 14 Dec 2016 10:31:44 GMT

hy,

the result of today()-30 is a number not a date, try "=date(today()-30)"

best regards

Re: Date filters in nPrinting 17

Wed, 14 Dec 2016 11:20:08 GMT

Thanks, Aaron but did not work.

First, if I apply the filter I do not receive the email. Which is weird.
Second, when I receive the email after removing the filter the data is not filtered out for the last 30 days.

Any suggestion?

Re: Date filters in nPrinting 17

aaron_ppmc — Wed, 14 Dec 2016 13:43:04 GMT

Hy Santiago,

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

ShowLast30Days 1

Re: Date filters in nPrinting 17

Thu, 15 Dec 2016 04:46:56 GMT

That made the work Aaron,

Many thanks

Re: Date filters in nPrinting 17

mkelemen — Thu, 15 Dec 2016 12:19:00 GMT

Hi,

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.

BR,

Matus