Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdelaqua
Creator
Creator

Dynamic user email and filtering

Hello,

I need some help setting this scenario ap in Nprinitng.

I have a dynamic dataset similar to this sample. it already has the email addresses for the recipients and the data should be filtered by recipient.

below is the sample data. how to set up Nprinting so each user only receive their own report(data).

Year Country Sales UserEmail
2021 UK 500 user01@email.com
2022 UK 650 user01@email.com
2021 Germany 700 user02@email.com
2019 Germany 400 user02@email.com

 

Thanks

Didier

Labels (2)
2 Solutions

Accepted Solutions
Lech_Miszkiewicz

HI, 

This was discussed many times:

Check this: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Email-Dynamic-List/td-p/1905648 and links inside of that topic and following as they describe use of Excel recipient import and creation of recipient filters required to achieve what you want.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Ruggero_Piccoli
Support
Support

Hi,

Based on the table you shared each user needs a filter that keeps data of a single country. You can create them and associate with users manually or importing via Excel file as suggested by @Lech_Miszkiewicz .

Am I missing something? If yes, please add more details. 

How Qlik NPrinting filters work is explained in details at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

Importing users from Excel files (including filters creation and association with related user) is explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...

If you are not familiar with Qlik NPrinting workflow I suggest you to start from https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Introduction/Get-started.htm

I hope it helps.

Best Regards,

Ruggero



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.

View solution in original post

3 Replies
Lech_Miszkiewicz

HI, 

This was discussed many times:

Check this: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Email-Dynamic-List/td-p/1905648 and links inside of that topic and following as they describe use of Excel recipient import and creation of recipient filters required to achieve what you want.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

Based on the table you shared each user needs a filter that keeps data of a single country. You can create them and associate with users manually or importing via Excel file as suggested by @Lech_Miszkiewicz .

Am I missing something? If yes, please add more details. 

How Qlik NPrinting filters work is explained in details at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

Importing users from Excel files (including filters creation and association with related user) is explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...

If you are not familiar with Qlik NPrinting workflow I suggest you to start from https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Introduction/Get-started.htm

I hope it helps.

Best Regards,

Ruggero



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.
ericdelaqua
Creator
Creator
Author

Thanks @Lech_Miszkiewicz @Ruggero_Piccoli .

 

I have gone through all your explanation and built a process that when the app reloads a file is generated with the user details and their filter (because we don't have the infomation and it is dynamic). 

an nprinting taks is then run to import the user/filter info before the report task runs. this has resolve the use my use case.

Thanks