Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

guruprem
Contributor III

Nprinting Monthly Reload

Hi Experts,

Can you confirm that Nprinting Apr 2018 has monthly reload option, which was missing in Feb edition.  

My requirement is to send a report on a 1st of every month. Since monthly schedule option is not available I created Qlik Sense front end variable called 'day' to display day part of today. At Nprinting side I have created a condition on 'day' =1 to publish the report. But practically condition is failing everyday including on the 1st of month.

Kindly advise how to proceed.

1 Solution

Accepted Solutions
Highlighted
Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting Monthly Reload

Monthly feature is not present in April release.

Methodology and workarounds were described on community many times - please search before duplicating topics!

please read below linked documents - they provide working functionalities.

If your condition does not work, then definitely there is something wrong with your variables or syntax (like missing "=" sign in front of variable, grabbing wrong value (numeric or text, since it is an actual dual value) or something similar).

Please provide us with information of all steps (with the code you have used and screenshots from qlik sense syntax, condition syntax etc.. to help you troubleshoot)

I would follow this methodology to achieve it:

NPrinting 17 - How to Generate Report every End Of Month

RESmiley Frustratedchedule specific day in a month

regards

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.
12 Replies
Highlighted
Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting Monthly Reload

Monthly feature is not present in April release.

Methodology and workarounds were described on community many times - please search before duplicating topics!

please read below linked documents - they provide working functionalities.

If your condition does not work, then definitely there is something wrong with your variables or syntax (like missing "=" sign in front of variable, grabbing wrong value (numeric or text, since it is an actual dual value) or something similar).

Please provide us with information of all steps (with the code you have used and screenshots from qlik sense syntax, condition syntax etc.. to help you troubleshoot)

I would follow this methodology to achieve it:

NPrinting 17 - How to Generate Report every End Of Month

RESmiley Frustratedchedule specific day in a month

regards

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.
guruprem
Contributor III

Re: Nprinting Monthly Reload

You are an Nprinting Rock Star Oh!

Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting Monthly Reload

Hi Guruprem - did you actually get it working, if so,could you share what was the problem that it did not work for you?

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.
guruprem
Contributor III

Re: Nprinting Monthly Reload

Yes I got it worked. As you pointed, problem is with my Variable declaration, earlier I declared it wrong.

blaise
Contributor III

Re: Nprinting Monthly Reload

Sorry for hi-jacking this thread but I have a slightly different solution i would like to present but also discuss with lech_miszkiewicz‌ and maybee also rpc

Instead of creating the variables needed for monthly / daily /weekly triggers on the connection you use to produce the report data my recommendation would be to create a simple qvw with a calendar containing all dates you need for all your NPrinting reports and then add the variables in here instead. Reload this qvw when needed and create the connection to this qvw for your NPrinting App.

The up-side with this solution would be that (hopefully) NPrinting does not need to reload the metadata for the "real" connection that might be a long-running and heavy on ressources task but instead reload the metadata for a very small qvw.

What you you say guys, it this a solution that will work not only on paper? It should not be any technical issues other than you will have a lot of connections to the same qvw but the million $ question would be;

Does Nprinting still needs to reload the master data for the "real" qvw - even though the data isn't needed to evaluate the task conditions?

When I have some spare time i will try to set-up a test case for this and see what the logs says (task execution logs for the reload metadata tasks)

Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting Monthly Reload

Hi Johan,

I do not see a reason why would you implement second application for condition evaluation?

  1. Using LOCAL connection - I agree that this would speed up condition evaluation and metadata generation process for this small app however if you are sticking to LOCAL connection - then you need to reload your main qvw to fetch fresh data otherwise you will be left with stale data!
  2. USING QVP or QlikSense connection - you don't need to reload metadata to fetch fresh data from qvw at all so additional application would only create more confusion and work load and dependecy. Therefore condition in nPrinting application would not create any overhead in such case.

regards

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.
Employee
Employee

Re: Nprinting Monthly Reload

Hi,

Next release, June 2018, will have monthly and yearly schedules.

So evaluate if you can wait, I suppose, the end of June. I don't know the exact release date right now.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.
blaise
Contributor III

Re: Nprinting Monthly Reload

good point with QVP connection. I still think its valid for LOCAL connection though, one big app (lets say 4 GB compressed on disc) will take quite some time to load the data just to evaluate if today = monthstart. Will be a lot quicker on a calendar only app (a few mb maybee).

You can also create all variables and flag fields you need in one app and do not need to alter the main qvws just to change from 1st of month to 2nd of month.

I will perform some testing on this so Im sure that QVP connections are quick for condition checks and that my assumption that the main qvw aren't "reloaded" when not performing any condintion check on them.

I don't understand what you mean with "left with stale data!". I create local connections to my source document folder on QDS - those are just as updated with fresh data as my QVS folder(s).

My QVW used for condition checks will of course be scheduled for reload every day at 00:00.

Br Johan

Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting Monthly Reload

Finally

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.
Community Browser