topic Re: Nprinting date range filter: from a fixed date to a dynamic date in Qlik NPrinting

Nprinting date range filter: from a fixed date to a dynamic date

Elyse — Wed, 21 Jul 2021 15:03:40 GMT

Hello,

I am trying to create a Nprinting filter which allows me to see PublishDate equal& greater than 6/13/2021 and equal& smaller than previous day.

So far I tried with Advanced Search

=([publish_date]>=date(44360, 'MM/DD/YYYY')*(Date(Today()-1)>=[publish_date])

and

=([publish_date]>=date('6/13/2021', 'mm/dd/yyyy')*(Date(Today()-1)>=[publish_date])

both returned nothing.

I tested both '=date(44360, 'MM/DD/YYYY')' and '=date('6/13/2021', 'mm/dd/yyyy')' part with Evaluated value function, they are working fine.

I use this frame to create dynamic date range filters a lot, it works. I assumed it's the fixed date part caused this issue.

Please advise, thank you in advance.

Elyse

Re: Nprinting date range filter: from a fixed date to a dynamic date

Frank_S — Wed, 21 Jul 2021 15:34:55 GMT

Hi @Elyse

Can you recheck the steps described in the video contained in the following link?

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-9

If your expressions work in your Qlik Sense dashboard, then they should also work in NPrinting if they are formatted correctly theoretically.

Kind regards...

Re: Nprinting date range filter: from a fixed date to a dynamic date

Lech_Miszkiewicz — Wed, 21 Jul 2021 23:21:35 GMT

Hi,

Maybe have a read and make sure you know how your field is created in Qlik Sense - this is most important. Note that dates are usually duals and may have timestamp on them too..

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

once you go through that you may want to have a read about advanced search options:

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/