Nprinting - Date Filter

mjamieweiler — Fri, 23 Mar 2018 13:14:12 GMT

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

Re: Nprinting - Date Filter

Tanalex — Fri, 23 Mar 2018 16:55:17 GMT

This should help.

Dynamic Filter Nprinting 17

Re: Nprinting - Date Filter

Lech_Miszkiewicz — Sun, 25 Mar 2018 23:38:06 GMT

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

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.

topic Re: Nprinting - Date Filter in Qlik NPrinting

Nprinting - Date Filter

Re: Nprinting - Date Filter

Re: Nprinting - Date Filter