Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Thabang231
Contributor III
Contributor III

NPrinting Filter on Date that uses auto Calendar dated by YearMonth field

I am currently experiencing errors with advanced search filters.  I want to filter my nprint to display the last month data .   In the application there is one field LoadDate to select for filtering the date - the date has  autoCalendar fields - LoadDate.autoCalendar.YearMonth.  How do I code a filter for the date part?  I want this filter to be there when I pull my report in nprinting, but the report is not pulling through or it cant work. Kindly assist.

Labels (2)
3 Solutions

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

I suggest you try the advanced search formula first on the Qlik Sense app you are using as Qlik NPrinting source and only when it works correctly there copy it in the advanced search filter. 

Qlik NPrinting doesn't evaluate the advanced search formulas, it sends them directly to Qlik Sense that returns the results so it has to work in Qlik Sense before.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Frank_S
Support
Support

Also, please note that NPrinting works with directly associative data and does not work with with triggered data and other limitations specified here:

Kind regards

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

I have already provided answers for this in the past: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Filter-on-Date-that-uses-auto-Cal... which do work and as @Ruggero_Piccoli said you need to use advanced search which will work.

cheers

Lech

 

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

5 Replies
Ruggero_Piccoli
Support
Support

Hi,

I suggest you try the advanced search formula first on the Qlik Sense app you are using as Qlik NPrinting source and only when it works correctly there copy it in the advanced search filter. 

Qlik NPrinting doesn't evaluate the advanced search formulas, it sends them directly to Qlik Sense that returns the results so it has to work in Qlik Sense before.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_S
Support
Support

Also, please note that NPrinting works with directly associative data and does not work with with triggered data and other limitations specified here:

Kind regards

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

I have already provided answers for this in the past: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Filter-on-Date-that-uses-auto-Cal... which do work and as @Ruggero_Piccoli said you need to use advanced search which will work.

cheers

Lech

 

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.
Thabang231
Contributor III
Contributor III
Author

Much Appreciation to everyone, the info and bit of research you provided really helped and I got the perfect answer following the above replies.

 

Frank_S
Support
Support

Awesome news!

Cheers...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!