Solved: Dynamic user email and filtering - Qlik Community

ericdelaqua · ‎2022-07-12

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

Lech_Miszkiewicz · ‎2022-07-12

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 · ‎2022-07-13

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.