Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

NPrinting 17 - How to Generate Report every End Of Month

hi all,

as we know NPrinting 17 is not able to generate report every end of month, in the schedule it only have Once, Daily and Weekly options.

so how if we want to generate report every end of month?

in this post i will share the trick to generate report every end of month (see attachment)

hope this post can help you

Regards,

Alfian

1 Solution

Accepted Solutions
peterbergman
New Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

Hi

In the version Qlik Nprinting june 2018 you can now use monthly and yearly schedules.

This is from the release notes pdf

Monthly and yearly schedule

Time-based triggers now allow the creation of monthly or yearly schedules.

This feature removes a gap between Qlik NPrinting 16 and 17+.

Best regards

Peter

17 Replies
woutermak
Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

as we know NPrinting 17 is not able to generate report every end of month, in the schedule it only have Once, Daily and Weekly options.

so how if we want to generate report every end of month?

in this post i will share the trick to generate report every end of month (see attachment)

hope this post can help you

Thanks. This is useful. Better then creating a lot of triggers for just one moment. I hope we will have soon a standard option to set it to monthly and per quarter.
Regards,
Wouter

kdmarkee
Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

Great documentation, thanks. We need to do something like this so I can't wait to set this up.

Employee
Employee

Re: NPrinting 17 - How to Generate Report every End Of Month

Eventually monthly/yearly schedules will be implemented so you'll be able to do things like last day of the month, first Monday of the month, etc.

Wouter's solution will work but you can also add multiple one-time triggers to a publish task and select the last day of each month:

Capture.PNG

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

This method really applies to 1st, Last, or any other day of the month. Using this technique you can tailor any frequency as it all can be based on Qlik script and its calendar.

it is good that you have brought it up!

well done mate

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
woutermak
Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

Is there already a release date available for a standard schedule per month option?
Nprinting September?

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting 17 - How to Generate Report every End Of Month

I have not seen this option in Sep 2017 version, but given that workaround is not hard to achieve i will not expect it to arrive soon.

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
dwforest
Valued Contributor

Re: NPrinting 17 - How to Generate Report every End Of Month

Still no Monthly Option? This is fairly industry standard stuff to have a month-end report; i don't think creating 12 schedules per report per year is a viable "work around" to a piece of missing core functionality.

Compound this with the inability to copy triggers, makes it a logistical and cumbersome, time consuming process.

Is it still on a roadmap?

berndjaegle
Contributor

Re: NPrinting 17 - How to Generate Report every End Of Month

Thank you Alifian for this helpful documentation!

Cheers,

Bernd

kotty5132
New Contributor

Re: NPrinting 17 - How to Generate Report every End Of Month

Unfortunately I can't see any variable that is in Qlik Sense app when creating a new rule in NPrinting. How would you do this if you have Qlik Sense?

What I see in my QS app:

Capture.PNG

Compared to what I can (not) see in the NPrinting rule section:

Untitled.png

Thanks

Jiri

Community Browser