Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

pablomind
New Contributor III

NPrinting 17.2 Dynamic Recipients

Hello everybody,

I have a QVW with all the info of the report that I need including users and the hotel which corresponds to each one of them. How can I make a filter in the NPrinting which select the right hotel to each user and match it with my Recipients excel where I have all the emails of each user (I use this excel to update the user in the NPrinting console)? Thank you for your help!

1 Solution

Accepted Solutions
Not applicable

Re: NPrinting 17.2 Dynamic Recipients

1) build a chart with all the users, email addresses and information for filters (syntax in this file: http://help.qlik.com/en-US/nprinting/17.2/tutorials/Examples.zip)

2) Export that chart into an Excel file using an NPrinting Excel format report

3) Import the users on the chart using the import task

This will allow you to dynamically keep users updated.

You will probably want to eliminate old users on every import if the hotel+user combination is constantly changing.

5 Replies
silvacarlos
Contributor II

Re: NPrinting 17.2 Dynamic Recipients

I have the same question, I need to do this but on Qlik Sense.

I hope that someone can help!

Thanks

CS

Not applicable

Re: NPrinting 17.2 Dynamic Recipients

1) build a chart with all the users, email addresses and information for filters (syntax in this file: http://help.qlik.com/en-US/nprinting/17.2/tutorials/Examples.zip)

2) Export that chart into an Excel file using an NPrinting Excel format report

3) Import the users on the chart using the import task

This will allow you to dynamically keep users updated.

You will probably want to eliminate old users on every import if the hotel+user combination is constantly changing.

tiklam_dynasys
Contributor

Re: NPrinting 17.2 Dynamic Recipients

Hi Carlos,

Did you find the solution?

Best Regards,

Louis

erikadvectas
Valued Contributor

Re: NPrinting 17.2 Dynamic Recipients

I have created a PowerShell script which solves this as well.

Import Nprinting Users from Active Directory automatically

For the filters you can do something similar, but in NPrinting 17.3 each user needs its owns filter, as it seems. So if you have 1000 emails to be sent (one per user) - you need 1000 filters.

cabhijit
Valued Contributor

Re: NPrinting 17.2 Dynamic Recipients

Hi, If we create 1000 filters each for every users, How can we ensure that respected users is picked from list of users and mail is only sent to selected users?

Community Browser