Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
neha_sri
Creator III
Creator III

Qlikview Alert

Hi Experts,

I have a table which have multiple users and regions associated to them. I want to send email alert notification to only those users whose region is not doing well.

I have gone through discussions in the communities but was not able to find scenario where mail recipients can be dynamic.

If anybody have any idea on this.

Thanks in advance.

Regards,

Neha

1 Solution

Accepted Solutions
Kushal_Chawda

1) 1st map the users(Email ID) to their respective region using QlikView inline load or you can maintain the excel file.

2) Now link the User(Email) to Actual data based on region.

3) Setup the SMTP server with User account from which mail should be triggered.Go to Qlikview application->Settings-> User Preference->Mail-> Here you can set the SMTP server with user account. Test the same.

4) Once email is configured in step 3, Create the alert with condition : sum(sales)<=2000 (write your actual condition for bad sales)

5) In recipient, put below expression to trigger the mail

    concat(EmailID ={"=sum(sales)<=2000"}>}EmailID,';')

View solution in original post

17 Replies
balrajahlawat
Champion
Champion

sandipsatbhai
Creator II
Creator II

are you want to send mail using Nprinting or Macro??

Kushal_Chawda

1) 1st map the users(Email ID) to their respective region using QlikView inline load or you can maintain the excel file.

2) Now link the User(Email) to Actual data based on region.

3) Setup the SMTP server with User account from which mail should be triggered.Go to Qlikview application->Settings-> User Preference->Mail-> Here you can set the SMTP server with user account. Test the same.

4) Once email is configured in step 3, Create the alert with condition : sum(sales)<=2000 (write your actual condition for bad sales)

5) In recipient, put below expression to trigger the mail

    concat(EmailID ={"=sum(sales)<=2000"}>}EmailID,';')

balrajahlawat
Champion
Champion

may be this like this as well?

QV Desktop -> Tools -> Alert Wizard ->A few clicks in choose On Post Reload.

vikasmahajan

See this link https://community.qlik.com/docs/DOC-3549

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

You can create  variable  vEmailRecipients and send the mail for multiple recipients.

  1. sub SendMail 
  2.   set Report_Table=ActiveDocument.GetSheetObject("Report_Table") 
  3.   ' Get Email recipient list stored in the varable vEmailRecipients 
  4.   var_emailRecipients = ActiveDocument.Variables("vEmailRecipients").GetContent.string 
  5.   'msgbox var_emailRecipients 
  6.   'format the mail body 
  7.   txtBody="<HTML><BODY><font face=""verdana"" size=""1""> Design and Planning Report <br> <br>" 
  8.   txtBody=txtBody & "<TABLE border=""1"">" 
  9.   For i=0 to Report_Table.GetNOOfRows 
  10.   txtBody=txtBody&"<TR>" 
  11.   txtBody=txtBody&"<Td><font face=""verdana"" size=""1"">" 
  12.   txtBody=txtBody&Report_Table.GetCell(i,0).text 
  13.   txtBody=txtBody&" </font></Td>" 
  14.   txtBody=txtBody&"<Td bgcolor="&Report_Table.GetCell(i,2).text &"><font face=""verdana"" size=""1"">" 
  15.   txtBody=txtBody&Report_Table.GetCell(i,1).text 
  16.   txtBody=txtBody&" </font></Td>" 
  17.   txtBody=txtBody&"</TR>" 
  18.   Next 
  19.   txtBody=txtBody&"</TABLE> </BODY></HTML>" 
  20.   Set gObjExcel=Nothing 
  21.   Set objMsg = CreateObject("CDO.Message") 
  22.   Set msgConf = CreateObject("CDO.Configuration") 
  23.   ' Server Configuration 
  24.   msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2  
  25.   msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smpthost"  
  26.   msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25  
  27.   msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1  
  28.   msgConf.Fields.Update 
  29.   ' Email 
  30.   objMsg.Subject = "Design and Planning Report" 
  31.   'objMsg.To = "testmail@domain.com"  
  32.   objMsg.Bcc= var_emailRecipients 
  33.   objMsg.From = "apptechsupport@domain.com"  
  34.   'assign body to the message 
  35.   objMsg.HTMLBody =txtBody 
  36.   Set objMsg.Configuration = msgConf 
  37.   objMsg.Send 
  38.   Msgbox("Report has been mailed.") 
  39.   ' Clear objects 
  40.   Set objMsg = nothing 
  41.   Set msgConf = nothing 
  42. end sub 

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
neha_sri
Creator III
Creator III
Author

Hi Kush,

i am getting error:

Could not connect to server.

Last response: Unexpected AUTH LOGINresponse, Last Response: 504

5.7.4. Unrecognized authentication type.

could you please help on this.

Regards,

Neha

neha_sri
Creator III
Creator III
Author

Hi All,

Hi All,

I am getting this error while sending mail from qlikview.

error.jpg

Regards,

Neha

Kushal_Chawda

Choose authentication type as never. Make sure that SMTP server IP or name is correct. Also make sure that the port between QlikView server where qlikview is installed and SMTP server is open. So that You can send the mail from QlikView server