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

NPrinting 17 - How to Generate Report every End Of Month

Wed, 25 Sep 2019 18:40:54 GMT

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

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

woutermak — Fri, 06 Jan 2017 10:31:56 GMT

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

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

kdmarkee — Fri, 02 Jun 2017 16:39:18 GMT

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

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

Stephen_Jasionowski — Fri, 02 Jun 2017 16:55:15 GMT

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:

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

Lech_Miszkiewicz — Sun, 04 Jun 2017 23:30:05 GMT

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

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

woutermak — Mon, 28 Aug 2017 08:11:35 GMT

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

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

Lech_Miszkiewicz — Tue, 29 Aug 2017 03:38:06 GMT

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

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

dwforest — Tue, 03 Apr 2018 20:40:03 GMT

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?

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

berndjaegle — Tue, 15 May 2018 07:49:32 GMT

Thank you Alifian for this helpful documentation!

Cheers,

Bernd

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

Kotty — Mon, 04 Jun 2018 08:41:54 GMT

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:

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

Thanks

Jiri

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

kdmarkee — Mon, 04 Jun 2018 15:18:20 GMT

Is it possible you forgot to reload the metadata in NP for your connection?

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

Kotty — Tue, 05 Jun 2018 07:03:47 GMT

That was indeed the root cause of my issue.

Thanks a lot.

Jiri

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

kdmarkee — Tue, 05 Jun 2018 16:07:45 GMT

You're welcome...glad it was something simple.

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

kfoudhaily — Tue, 05 Jun 2018 16:24:30 GMT

Hello,

for a very specific NPrinting tasks loading, I have worked on a qlikview script that is able to lunch a set of a predefined NP tasks, then you can plan the tasks from QMC wich is more suitable for your need.

here is the article in english: How to use Qlik NPrinting APIs inside a Qlik View load script

Here is the original version in french: Déclencher une tâche Qlik NPrinting à partir du script de chargement Qlikview:

regards,

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

peterbergman — Mon, 30 Jul 2018 07:37:59 GMT

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

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

SanthoshEmmadi — Mon, 06 Aug 2018 13:06:14 GMT

Hi,

NPrinting 17 with June 2018 release has given the option to schedule a report monthly & yearly. Please install the June 2018 version to use this option.

Regards,

Santhosh

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

manishrawat_jub — Mon, 14 Jan 2019 18:38:13 GMT

Hi All,

Where is the document to set Monthly schedule for NPrinting report.

Thanks in advance!

Regards,
Manish Rawat

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

Daniel_Jenkins — Mon, 14 Jan 2019 21:38:46 GMT

Hi Manish,

See:

https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/DistributionSchedulesAutomation/Distribute-User-Specific.htm#Creating

HTH - Daniel.