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

[Thabang231]

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.

[Ruggero_Piccoli · Accepted solution]

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

[Frank_S · Accepted solution]

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

• Unsupported Qlik Sense Object Support and L... - Qlik Community - 1717018

Kind regards

[Lech_Miszkiewicz · Accepted solution]

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

[Thabang231]

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]

Awesome news!

Cheers...