Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mjamieweiler
New Contributor

Nprinting - Date Filter

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

Tags (1)
2 Replies
marmentrout5
Contributor

Re: Nprinting - Date Filter

This should help.

Dynamic Filter Nprinting 17

Re: Nprinting - Date Filter

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.