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: 
kunalpatil119
Contributor II
Contributor II

nprinting monthly report till last Month (to be dyncamically generated)

I want help on nprinting.
In my report calendermonth field is present.
I want to Email Monthly report on day 1st day of every month till last Month.
e.g.assume today is 1st of may the report should sent data till April. (Jan Feb March April)
e.g.assume today is 1st of June the report should sent data till May.(Jan Feb March April May)
e.g.assume today is 1st of Jan the report should sent data all months of last year(all 12 years)

How can I create dynamic filter on Calendermonthname or calendermonthnumber etc.

 

Your immediate help is much appreciated

 

 

 

Labels (4)
3 Replies
Andrea_Bertazzo
Support
Support

Hi Kunalpatil119,

An option could be to create a filter for the current month and the use the Select Excluded option:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
Ruggero_Piccoli
Support
Support

Hi,

This topic was discussed many times in the past on community posts so I suggest you to start by searching and reading them. For example https://community.qlik.com/t5/Qlik-NPrinting-Discussions/FILTER-CURRENT-MONTH/td-p/1804558

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.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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.