Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Nprinting Excel report for specified users

Hi Everyone,

Please help me to send mail (with excel report) to specified user for Nprinting.

Please refer the attached sample.xlsx, I have the table with 14 records. I have below requirement:

  1. Send the report to users in column "Email" for their corresponding records only. Example: Send the buyer 'Swiss Auto Company' details only to user: Joseph123@email.com

Note: Users might be vary every day and report having the following fields only: Buyer Name, Policy Number, Previous Date, Previous Buyer Rating, Current Date, Current Buyer Rating and Agent Name.

Thanks in Advance.

Regards

Jhanaarthanan

4 Replies
Creator
Creator

You can create a Import task with a trigger daily. In the import task link the xlsx with the users using the follow template:

https://help.qlik.com/en-US/nprinting/April2018/Content/DeployingQVNprinting/Import-Users-Filters.ht...

Create a filter for the user Joseph123@email.com declaring the possibles values for the field Buyer Name and Policy Number. Add the filter to the user.

Create a Publish task and add the report. Nprinting use the use filter for each recipient.

Employee
Employee

Hi,

For more details refer to the help site https://help.qlik.com/en-US/nprinting/April2018/Content/Introduction/Introduction.htm.

Creating Excel templates, filters, importing users etc are all well explained there.

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

Hi Gastavo,

Thanks for your information.

But my Nprinting version is 16.7.0.0, is it your solution will support this version?! the link (https://help.qlik.com/en-US/nprinting/April2018/Content/DeployingQVNprinting/Import-Users-Filters.ht...) mentioned that it will support only Nprinting Version 17 and above.

Please clarify.

Thanks & Regards

Jhanaarthanan

Contributor III
Contributor III

Thanks Ruggero!