topic Re: How can i send automatic mail based on data selection in QlikView

How can i send automatic mail based on data selection

Tue, 12 Aug 2014 14:21:51 GMT

Hi all,

I need to apply the below logic in the uploaded sample QV.

Based on the column (Remaining time) , if it is less than 2(hr) automatic mail needs to be sent to the team (Group) with the subject as ticket number(Case Id) .

The above logic will be checked based on on open or reload of the application. Please suggest your idea.

CASE ID	Remaining_Time	Group
IM740410	1	Test A
IM741550	2	Test A
IM741556	4	Test C
IM741644	4	Test A

Re: How can i send automatic mail based on data selection

p_verkooijen — Tue, 12 Aug 2014 14:45:00 GMT

I see you tried using Alerts, however you need to use AGGR to determine which CASE's are due.

See attachment

Re: Re: How can i send automatic mail based on data selection

Tue, 12 Aug 2014 15:04:44 GMT

Hi Paul,

Thanks a lot for the logic that you have used. It is exactly the same that i wished as, can you please help me out in one more logic in the application ,

How can i set the mail recipients automatically based on satisfying the above conditions. So that in mail recipient (alert) field it is not necessary to enter all the mail ids.

IM743087	2	Test A	abcd@gmail.com
IM743097	1	Test D	abcd@hotmail.com
IM743163	1	Test D	abcd@hotmail.com
IM743293	2	Test D	abcd@hotmail.com
IM743297	1	Test D	abcd@hotmail.com
IM743298	1	Test D	abcd@hotmail.com
IM743299	1	Test D	abcd@hotmail.com
IM743300	1	Test D	abcd@hotmail.com
IM743301	1	Test D	abcd@hotmail.com
IM743302	1	Test D	abcd@hotmail.com
IM743375	1	Test D	abcd@hotmail.com
IM743376	1	Test D	abcd@hotmail.com

Re: How can i send automatic mail based on data selection

p_verkooijen — Wed, 13 Aug 2014 07:04:47 GMT

You need to create separate alerts, then use Set Analysis to create an alert for Group TestA and Group TestB

{<Group={'Test A'}>}

Re: How can i send automatic mail based on data selection

DavidFoster1 — Wed, 13 Aug 2014 07:17:24 GMT

I know you have a solution to your question, but I would recommend that you look at third party reporting options like NPrinting for this kind of work instead of using alerts. Alerts require the document to be open in desktop or in IE client, which is a 'stop gap' type of approach.. Whereas something like NPrinting can be set to run on a formal scheduled batch process.

You also can have greater flexibility about the information contained in the emails if you dont rely on Alerts' limited options.

Re: How can i send automatic mail based on data selection

Wed, 13 Aug 2014 07:59:44 GMT

Hi Paul,

Should i apply the set analysis in the mail recipients alert. Can you pls give a example.