topic Re: Automatic Recipient from a SQL View in Qlik NPrinting

Automatic Recipient from a SQL View

Anonymous — Tue, 13 Dec 2016 14:23:50 GMT

Hi,

I'm a bit of a newbie at this, and this has probably been answered before, I just can't find anything close.

I am loading a SQL view into Qlik which looks like the following:

ASM	ASMEmail	ActiveAccount	Spend
Fred Smith	FredSmith@sales.com	RGS & Sons	34000
Fred Smith	FredSmith@sales.com	Smile Ltd	25000
Fred Smith	FredSmith@sales.com	Greeves Ltd	67000
John Brown	JohnBrown@sales.com	Wrights of Slough	100
John Brown	JohnBrown@sales.com	Jims or Ipswich	56000
John Brown	JohnBrown@sales.com	Blueway	100000

What I would like to do is Email a single report to each ASM on a monthly basis showing all of his active accounts and the associated Spend. - a simple two column spreadsheet. How do I take the ASMEmail from the data and create it as a recipient?

Thanks

Re: Automatic Recipient from a SQL View

alexpanjhc — Tue, 13 Dec 2016 22:20:19 GMT

I am not sure what you meant automatic, but here is how I created.

When the above chart is created, you can send them to an excel file.

Go to the recipient ->recipient import->From File(this is the file you just created)-> following the instruction of the steps. remember to select the excel file.the at the last step to map the fields.

its a straight process.

Or you can import by entity too.

Hope this helps.

Re: Automatic Recipient from a SQL View

Anonymous — Wed, 14 Dec 2016 08:42:38 GMT

Hi thanks for the response, but not quite what I'm looking for. let me elaborate:

I need to use nPrinting/Qlik to send an email to each of the ASM's at month end. The bit I don't know how to do is, dynamically pick up their email addresses from the data?

From the above example:

Fred Smith get's one email containing a three row spreadsheet showing the spend on his accounts.

John Brown also get's one email containing a three row spreadsheet showing the spend on his accounts.

I have written the reports and scheduled them.... I'm just lacking how to dynamically grab their email addresses.

thanks

Re: Automatic Recipient from a SQL View

vincent_ardiet — Wed, 14 Dec 2016 08:52:53 GMT

Hi Simon,

Do you have a Publisher license in your QlikView installation?

With it you will be able to do this easily.

Else, you may need to create a macro.

Re: Automatic Recipient from a SQL View

Anonymous — Wed, 14 Dec 2016 09:00:15 GMT

Hi Yes we do.

Re: Automatic Recipient from a SQL View

vincent_ardiet — Wed, 14 Dec 2016 10:04:08 GMT

Your answer and mine have crossed.

So, if you are using nPrinting, no need of the Publisher.

You will have to create recipients (they can be done by a task importing them from your QV application) with recipient's filter.

Those filters will be applied by nPrinting when creating the reports for each recipient.

See this thread Nprinting - Recipients Filters dynamically, you will have useful links.