topic Re: NPrinting Date Filter Not Working in Qlik NPrinting

NPrinting Date Filter Not Working

elduderino — Wed, 25 Sep 2019 18:40:54 GMT

Hello All,

I am trying to craft a date filter in NPrinting version 19.0.3.0 . My report is to only show the past 13 months of a chart, and the filter works within the dashboard but not the output into Excel.

I've tried adding the filter to the report, to the task, and within "Edit Template" of the report on each individual table- all to no avail.

The calculated dimension on the chart is as follows.:

=if(SC.MonthYear>= addmonths(today(),-13), SC.MonthYear)

It works on the actual dashboard (showing only the past 13 months), but will not transfer to NPrinting since all dates are shown.

Can anyone help? I cannot get this to work for the life of me! Thanks in advance!

Re: NPrinting Date Filter Not Working

Frank_S — Wed, 31 Jul 2019 16:58:56 GMT

It appears that you are attempting to calculate an array of values

" >= " equal to and greater than "

This is not supported. https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ExcelReports/Formulas.htm

"Formulas used in Qlik NPrinting must evaluate to a unique value.

However, the June 2019 release of NPrinting has 'advanced search' feature that may help you to achieve your requirement.

See the following link for information about this feature:

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

For additional examples, see the link below:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Examples-of-Advanced-Search-Filters/ta-p/1594779

Hope this helps...

Re: NPrinting Date Filter Not Working

Lech_Miszkiewicz — Wed, 31 Jul 2019 23:49:47 GMT

If you are not ready for an upgrade please have a read on my blog regarding how you can workaround what you are trying to do:

https://nprintingadventures.wordpress.com/

cheers

Re: NPrinting Date Filter Not Working

elduderino — Thu, 01 Aug 2019 15:57:21 GMT

Thanks to both of you for your help! I ended up creating a date range flag in the load script to obtain the desired result.