Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 

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.



2 Replies
Creator II
Creator II

This should help.

Dynamic Filter Nprinting 17

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)





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.