Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elduderino
Contributor II
Contributor II

NPrinting Date Filter Not Working

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. Capture.PNG

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

1 Solution

Accepted Solutions
Lech_Miszkiewicz

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

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.

View solution in original post

3 Replies
Frank_S
Support
Support

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:

For additional examples, see the link below:

Hope this helps...

 

 

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Lech_Miszkiewicz

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

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.

View solution in original post

elduderino
Contributor II
Contributor II
Author

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.