Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Alert Email integration

Dear Members,

I am using QV 9 .00.7119.4 and was successful in generating the alert

I used following condition in alert window:


(Aggr(If(Sum(Sales)<=100, 1), Country)) >0

and in message window i used following condition:


'Number of countries below 100 = ' & Count(if(Sales<=100,Country)) & chr(13

) &

'Countries: '

& Concat(if(Sales<=100,Country), ',

I was able to get the alert message window.

Now i was reying to send this alert as email

I went to email window and used the following details

Sender email id:vupreti@data.com mailserveraddress

encoding'western european smtp.1and1.com



And then i clicked on apply and o.k button

I got the following error message

QlikView - Reseller's Copy
Couldn't connect to server!
Last Response: An attempt was made to access a socket in a way forbidden by its access permissions.


I used ping : smtp.1 and 1.com and i got reply also

Pinging smtp.1and1.com [] with 32 bytes of data:

Reply from bytes=32 time=342ms TTL=44
Reply from bytes=32 time=340ms TTL=44
Reply from bytes=32 time=340ms TTL=44
Reply from bytes=32 time=341ms TTL=44

Ping statistics for
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 340ms, Maximum = 342ms, Average = 340ms

where could be the problem.

Guys can u help me out..



0 Replies