topic Re: Qlikview Alert in QlikView

Qlikview Alert

neha_sri — Wed, 16 Mar 2016 10:30:37 GMT

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

Re: Qlikview Alert

Anonymous — Wed, 16 Mar 2016 10:37:49 GMT

QlikView® NPrinting | Qlik

http://www.qlik.com/products/qlikview/nprinting

or you can use Macro, like this?

Useful Qlikview Macros

Re: Qlikview Alert

Anonymous — Wed, 16 Mar 2016 10:40:17 GMT

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

Re: Qlikview Alert

Kushal_Chawda — Wed, 16 Mar 2016 10:41:33 GMT

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,';')

Re: Qlikview Alert

Anonymous — Wed, 16 Mar 2016 10:46:23 GMT

may be this like this as well?

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

Re: Qlikview Alert

vikasmahajan — Wed, 16 Mar 2016 11:08:40 GMT

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

Vikas

Re: Qlikview Alert

vikasmahajan — Wed, 16 Mar 2016 11:11:00 GMT

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

sub SendMail
set Report_Table=ActiveDocument.GetSheetObject("Report_Table")
' Get Email recipient list stored in the varable vEmailRecipients
var_emailRecipients = ActiveDocument.Variables("vEmailRecipients").GetContent.string
'msgbox var_emailRecipients
'format the mail body
txtBody="<HTML><BODY><font face=""verdana"" size=""1""> Design and Planning Report <br> <br>"
txtBody=txtBody & "<TABLE border=""1"">"
For i=0 to Report_Table.GetNOOfRows
txtBody=txtBody&"<TR>"
txtBody=txtBody&"<Td><font face=""verdana"" size=""1"">"
txtBody=txtBody&Report_Table.GetCell(i,0).text
txtBody=txtBody&" </font></Td>"
txtBody=txtBody&"<Td bgcolor="&Report_Table.GetCell(i,2).text &"><font face=""verdana"" size=""1"">"
txtBody=txtBody&Report_Table.GetCell(i,1).text
txtBody=txtBody&" </font></Td>"
txtBody=txtBody&"</TR>"
Next
txtBody=txtBody&"</TABLE> </BODY></HTML>"
Set gObjExcel=Nothing
Set objMsg = CreateObject("CDO.Message")
Set msgConf = CreateObject("CDO.Configuration")
' Server Configuration
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smpthost"
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
msgConf.Fields.Update
' Email
objMsg.Subject = "Design and Planning Report"
'objMsg.To = "testmail@domain.com"
objMsg.Bcc= var_emailRecipients
objMsg.From = "apptechsupport@domain.com"
'assign body to the message
objMsg.HTMLBody =txtBody
Set objMsg.Configuration = msgConf
objMsg.Send
Msgbox("Report has been mailed.")
' Clear objects
Set objMsg = nothing
Set msgConf = nothing
end sub

HTH

Vikas

Re: Qlikview Alert

neha_sri — Thu, 17 Mar 2016 08:01:28 GMT

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

Re: Qlikview Alert

neha_sri — Thu, 17 Mar 2016 08:10:40 GMT

Hi All,

I am getting this error while sending mail from qlikview.

Regards,

Neha

Re: Qlikview Alert

Kushal_Chawda — Thu, 17 Mar 2016 08:36:22 GMT

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

Re: Qlikview Alert

neha_sri — Thu, 17 Mar 2016 10:44:09 GMT

Hi Kush,

I am able to send test mail now, but when i am entering the receipient name in Mail receipient box its not working,the mail is not sent to anybody. Am i missing something?

Regards,

Neha

Re: Qlikview Alert

Kushal_Chawda — Thu, 17 Mar 2016 12:20:00 GMT

Enter the Email ID of the user to whom you want to send the Email in Mail recipient. Make sure that Email id is valid.

Re: Qlikview Alert

neha_sri — Fri, 18 Mar 2016 11:15:35 GMT

Hi Kush,

is it possible to send mail row wise. Eg:

Amount	User	Region
100	A	X
200	B	Y
300	A	Z

I have to send mails to all of them as they have not meet their goal of 500.

My scenario is :

I want to send mail to A two times. One for Region X and other for Region Z.

and other mail to B for Region Y.

Is it possible??

Regards,

Neha

Re: Qlikview Alert

neha_sri — Fri, 18 Mar 2016 11:16:39 GMT

is it possible to send mail row wise. Eg:

Amount	User	Region
100	A	X
200	B	Y
300	A	Z

I have to send mails to all of them as they have not meet their goal of 500.

My scenario is :

I want to send mail to A two times. One for Region X and other for Region Z.

and other mail to B for Region Y.

Is it possible??

Regards,

Neha

Re: Qlikview Alert

Chanty4u — Fri, 18 Mar 2016 11:17:08 GMT

chk dis

One alert per row

Re: Qlikview Alert

neha_sri — Fri, 18 Mar 2016 11:19:49 GMT

Hi Chanty,

Thanks for Prompt reply, but my scenario is different. I have one more parameter that is region.

I have to send mail region wise to User based on amount

Regards,

Neha

Re: Qlikview Alert

Kushal_Chawda — Sat, 19 Mar 2016 07:21:30 GMT

Yes, it is possible. In email body you can send the figures as Table format using Aggr & Concat function. So there is no need to send the Trigger twice for the same user. In single trigger only you will be able to Send the report for both Region for that user.

See the below link

QlikView App: Send Data In QlikView Alerts

Re: Qlikview Alert

neha_sri — Mon, 21 Mar 2016 09:19:21 GMT

Hi Kush,

How can I have dynamic recipients and the msg body should generate based on user. Every user should not get same mail text. They should get their respective mail text containing their respective values.

Regards,

Neha