topic Re: Dynamic user email and filtering in Qlik NPrinting

Dynamic user email and filtering

ericdelaqua — Wed, 13 Jul 2022 00:36:50 GMT

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

Re: Dynamic user email and filtering

Lech_Miszkiewicz — Wed, 13 Jul 2022 03:05:52 GMT

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

Re: Dynamic user email and filtering

Ruggero_Piccoli — Wed, 13 Jul 2022 08:42:56 GMT

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-filters.htm

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-Filters.htm

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

Re: Dynamic user email and filtering

ericdelaqua — Wed, 27 Jul 2022 00:50:31 GMT

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