Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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