Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rajtechnocraft
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:



Sum

(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

Port:587

Authentication:none

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.


---------------------------
OK
---------------------------

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


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

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

Ping statistics for 74.208.5.17:
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..

Thanks..

)



0 Replies