Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kunalpatil119
Contributor II
Contributor II
‎2020-05-20 02:05 AM

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

 

 

 

681 Views
0 Likes
3 Replies
Andrea_Bertazzo
Support
Support
‎2021-05-31 12:50 PM

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 ! 🙂
591 Views
0 Likes
Ruggero_Piccoli
Support
Support
‎2021-06-01 03:24 AM

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.
580 Views
0 Likes
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2021-06-01 05:57 AM

In response to Ruggero_Piccoli

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.
573 Views
0 Likes