Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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