topic Re: NPrinting Date filter Problem in Qlik NPrinting

NPrinting Date filter Problem

ecabanas — Tue, 09 Jun 2015 11:26:15 GMT

Hi,

I'm creating a filter in a date field, I would like to show the items sold yesterday and the formula in the filter is:

=num(now()-1,'#####')

the dateformat in Qliview is numeric yesterday= 42163

and the report did not recognize the date

Thank's in advance

Eduard

giakoum — Tue, 09 Jun 2015 11:30:18 GMT

now contains time as well.

floor it to show only date

num(floor(now()))

or use today()

avinashelite — Tue, 09 Jun 2015 11:32:17 GMT

hi,

dont use now it has time associated with it. Try with today() and keep the variable and column date format same .

Date(today()-1,'DD-MM-YYYY')

Anonymous — Tue, 09 Jun 2015 11:33:23 GMT

You can also create a variable in the application and call that filter to NPrinting which is one of the easiest way.

It happened to me in one of the application

ecabanas — Tue, 09 Jun 2015 14:57:30 GMT

Many thank's Ioannis 😉