Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set up dynamic filters, scheduling and tasks in NPrinting 16

Hi Guys,

Overview

  • I have 5 different excel reports
  • 8 different customers.
  • All 8 customers will get reports they are assigned to.
  • And the report has a customer field 'Cycle' so each customer only gets their data.

Complexity.

  • All 8 customers have different report schedules
  • Weekly, Bi-Weekly or Monthly
  • And they should only get their report based on their Reporting Schedule and only contain data for that date range

Report ScheduleDelivery Date
Monthly1st of the month
Twice Monthly

1st of the month

16th of the month

Weekly

1st Monday of the month

  • Only if the 1st day of the month is a Tuesday or Wednesday)

2nd Monday of the month
3rd Monday of the month
4th Monday of the month
5th Monday of the month (do nothing)
1st day of every month

It is not an easy one but just wanted your opinion / feedback / techniques to achieve this.

Is it even possible that NPringing can run tasks and apply filters based on the above mentioned logic?

9 Replies
Specialist III
Specialist III

You might trigger jobs for nprinting from QMC based on some condition.

How to Distribute Reports after Successful .qvw Reload on a QlikView Server with Publisher

Not applicable

Hi Agnivesh,

Thank you for your reply. I forgot to mention in my post that I do not have Publisher.

I only have Qlikview SMB Server.

Not applicable

I have the same question.

I need to have conditions for task.... how we can do this? Or, which workaround we can make to have something like conditions for tasks?

Not applicable

Hi All,

I have got a workaround and it is working smooth. Its not as easy to explain here as a comment so I will be uploading a full solution with setp-by-step guide and a video in the fourm over the weekend.

Will post a link here soon so you guys can implement it too.

Not applicable

Do you resolve this issue on QlikView side or with NPrinting?

Not applicable

I have resolved my issue with help of collaboration between NPrinting in QlikView + conditions on NPrinting report.

Sorry for disturbing you.

Not applicable

Its little bit of everything

I have implemented reporting schedule table in the SQL database and a C# code for the primary application.

  • I have added an extra field in the Customer table to record their billing schedule 'Weekly, Twice Monthly or Monthly'
  • I have also created an extra table in the database that records billing date, min date and max date for that billing schedule
  • The c# code executes overnight that checks every order tags them with billing shcedule ID based on when order was created and who is the customer.

Now at the QlikView side.

  • I have created variables vBillingDate, vMinDate and MaxDate
  • This variable values gets set based on the billing Schedule table in the SQL

Now at the NPrinting side.

  • The report job runs every morning at 5 AM but it will only execute if vBillingDate = Date(Today())
  • If Billing Date in the database = Today then Qlikview will set vMinDate and vMax date according to that specific billing schedule
  • and nprinting will apply filter on the reports as dates between vMinDate and vMaxDate.

It sounds very confusing but i will put it on a paper over the weekend.

Not applicable

I will also share GitHub link for the c# code and you can tweak it based on your data model and requirements

Not applicable

to myself )))