Send QlikSense reports via email by ZIP code in 2021

[virilo_tejedor]

Hi,

I'd like to send the same QlikSense app to 1500 email addresses corresponding to 1500 ZIP codes.  Just after the daily application reload task.

It should send the same report, but filtering data for the corresponding ZIP codes.

I've the ZIP/email address relationship in a table:

ZIP	email
10000	john@mycompany.com
10001	doe@mycompany.com
....	....

I would contain the dashboard info embedded in the email body, or exported as a .pdf.

So, it would generate 1.500 different email body/attachments, filtering by one different ZIP code per email.

I've seen videos and resources on sending email with Qlik Connectors (alerts only, I think), Qlik NPrinting and Qlik App Automation.

Is it possible with any of these technologies?

How could I achieve this?

Thanks in advance

[AshutoshBhumkar]

Hello,

You can achieve this using Qlik NPrinting (No idea about Qlik Alerts).

What is takes is Qlik sense dashboard, an Import file containing Email id, Name, User level filter (Zip code in your case) and NPrinitng task to send  mails.

You can get the configuration and user level mails details on below links.

https://www.youtube.com/watch?v=sGqIY4-Hacg

https://www.youtube.com/watch?v=-gn9zdyhtug

https://www.youtube.com/watch?v=Cea5_eO4V-c

Thanks,

Ashutosh

[virilo_tejedor]

Thanks a lot @AshutoshBhumkar !

The videos show how to import a users database with their columns filter into NPriting.

So I can figure out that I would only have to configure the report and send to them.
I assume that NPrinting would apply the filters before sending the email (I could test it before)

Is there any way, using a REST API or similar, to ask NPrinting for a single report and give the filters to apply as parameters to the REST service call?

[AshutoshBhumkar]

Sorry, I have to search for that. 

No clue for now 🙂