topic Re: Sending emails based on Fields in Qlik NPrinting

Sending emails based on Fields

bashar_f — Mon, 25 Jan 2016 11:49:05 GMT

Hi guys, I have a straight table in QlikView that reloads on a daily basis and and it will show records based on a date condition. For Example.

This is the table in the database.

Order Table:

Order Number Expected Delivery Sales Person Email

-----------------------------------------------------------------------------------------------------------------------

0001 8/2/2016 John John@company.com

0002 8/2/2016 Mark Mark@company.com

0003 6/4/2016 Joseph Joseph@company.com

Below is how the Straight table in QlikView would look and it's called "Reminder". It will only show records of the orders that have a delivery date of two weeks from now.

so it will show this today (25th of Jan), but tomorrow it will be blank because that condition is not met anymore.

Reminder Table:

Order Number Expected Delivery Sales Person Email

-----------------------------------------------------------------------------------------------------------------------

0001 8/2/2016 John John@company.com

0002 8/2/2016 Mark Mark@company.com

My Question is, How can i set up a task that sends an email to each of the sales persons using the email fields in the table through Nprinting?

Re: Sending emails based on Fields

Anonymous — Mon, 25 Jan 2016 15:17:05 GMT

Hi Bashar,

What you are trying to accomplish seems doable using conditional filters. I have attached a link to a thread with instructions for setting them up. I would start there and if you come across a specific issue that you can't resolve, post it back here and we will see if we can help you solve it.

QlikView NPrinting Tutorials - Conditional Execution

Regards,

Mike

Re: Sending emails based on Fields

bashar_f — Tue, 26 Jan 2016 09:38:46 GMT

Hi Mike,

Thanks for your reply.

I went through the link you shared, but I couldn't find anything that would accomplish what I'm trying to do, or maybe I didn't understand it well. I'll try to explain in more detail what it is I want Nprintng to do, if you still think that way is the right way, i'll look more into it.

Basically, when a day passes and the Reminder table becomes like this:

Reminder Table:

Order Number Expected Delivery Sales Person Email

-----------------------------------------------------------------------------------------------------------------------

0001 8/2/2016 John John@company.com

0002 8/2/2016 Mark Mark@company.com

Lets say I set up a schedule everyday at 8 am to check the reminder table and if it has data (For example, the above) then I want an email to be sent to John as the following:

"Dear John,

Please note that your order numbered 0001 is two weeks from reaching the expected delivery date"

and Mark would receive :

"Dear Mark,

Please note that your order numbered 0002 is two weeks from reaching the expected delivery date"

Thanks for your help

Re: Sending emails based on Fields

Stephen_Jasionowski — Tue, 26 Jan 2016 17:58:43 GMT

Bashar -

Mike has you going down the right path. Specifically, refer to this document and the example it contains: How to Control Report Generation with Conditions

In our training repository, we have an Excel report set up using a condition based upon whether or not a QlikView table contains values. Our example is a table that only shows salespeople who have exceeded $250K in sales, but you already have that logic set up for your exception table.

You will want to create a condition in NPrinting using your exception table as the chart ID and then selecting "has values" from the drop-down as shown here:

Attach the condition to the report template being used for the data in the email. From here you would also want to load recipient data for your salespeople into NPrinting, including their names, email addresses and presumably any filters you would want associated with them (e.g. a certain territory for which they should see data).

You can also set up a filter on the sales person name or email address so that John only sees his order data, Mark only sees his, and so on.

The next step is to create a report task that includes the conditional report and the sales people that are part of the relevant data set.

This way, when you set up a report task involving the conditional report, it will first check to see if there is any data in the exception table, and if so, then create an email and report for each sales person in the table.

Re: Sending emails based on Fields

Anonymous — Tue, 26 Jan 2016 18:09:34 GMT

Well, now that I think about it, you don't really need to use conditions. Using Set Analysis in QV you should be able to create a static table with only the records that need to get reminders and NPrinting can send to all records it finds in that table.

So, create your cyclic report in Word or whatever template you want to use and run it on your scheduler after your refresh loads.

Re: Sending emails based on Fields

marishnagendran — Thu, 20 Aug 2020 07:40:22 GMT

Hi Bashar,

You had a solution for this?

Re: Sending emails based on Fields

Lech_Miszkiewicz — Thu, 20 Aug 2020 11:04:04 GMT

Hi @marishnagendran

This topic is to old to discuss in this thread. Too much has changed since it was posted.

Please open new topic, provide detailed description of the versions yu use, setup, QlikView or Qlik Sense, NPrinting versions. Please provide correct labels of versions you are using.

When creating post please describe your requirements and support them with screenshots, mockups and samples

thanks

Lech

Re: Sending emails based on Fields

Vikash2024 — Thu, 28 Nov 2024 07:23:48 GMT

Can we do with Qlik Automation without using N-Printing ?

Re: Sending emails based on Fields

Lech_Miszkiewicz — Thu, 28 Nov 2024 12:04:17 GMT

Hi @Vikash2024

no point talking about unrelated topics here - if you wish to discuss particular automation question please post detailed question in related forum: https://community.qlik.com/t5/Reporting-Service/bd-p/reporting-service

Automation and NPrinting are separate products running on completely different platforms so no sure what your question is about.

cheers