Nprinting - Date Filter

[mjamieweiler]

Good Morning,

I'm new to nprinting and I'm trying to add a dynamic date filter.  I was successful in creating a filter for the current year, however creating a filter for a dynamic date is proving to be a bit more of a challenge.

I want to have a filter which is TODAY()-1.  Any suggestions on how I can accomplish this task.

Regards,

Jamie

[Tanalex]

This should help.

Dynamic Filter Nprinting 17

[Lech_Miszkiewicz]

Hi Jamie,

Below is official help document instruction. get familiar with it and it will solve your problem.

One remark:

As you want to return date value it can be a text, number/integer or dual value in ...  You need to check how this fiield is recognized  in Qlik.

If it is text - then you need to apply in your filter: =text(date(today()-1,'DD-MM-YYYY')) formatting where DD-MM-YYYY needs to be adjusted to mask you are using

If it is dual or integer then you need formula like =num(today()-1)

https://help.qlik.com/en-US/nprinting/February2018/Content/ReportsDevelopment/Static-dynamic-filters...

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.