Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

command for Email

Hi ,

Is it possible to send an email throguh Script (not as a  Button Click) command.

I want to send an email if the amount(ITEM_AMT) exceeds over a specifc value.

Thanks inadvance.

14 Replies
jschrader
Contributor III
Contributor III

Under tools, alerts, you can send emails based upon conditions. Also, the email can be sent after an event such as a reload.

bill_markham
Champion III
Champion III

Jhansi

These Alerts that Jason suggests are what I use & they work perfectly for me.

I have seen posts on this community from people who cannot get such Alerts to work.  I'll be interested to see how you fare.  Dont be out off by my saying this,as it works fine for me & should do also for you.

There was a QlikView SR that had problems with Alerts, what version are you using ?

Not applicable
Author

Hi Jason,

Thank you for your quick response. Yes. I can send the alert in this way. The problem is It is based on alert List.xls file which has the follwing fields like

Region ,Country ,Customer, Amount ,EmailID

So If a particular customer amount exceeds a specific value then need to send to the Eamil specified and this alert List.xls keep on changing every day.

Not applicable
Author

I am using QV11.2 SR7

rwunderlich

It's a little challenging to fire a variable number of alerts to different email addresses. You may find it easier to use a commandline email program like blat and call the program using the script EXECUTE command.

-Rob

jschrader
Contributor III
Contributor III

Rob,

I was wondering if you could explain how to calculate the actual RAM impact that we talked about at the conference? Thanks!

rwunderlich

Hi Jason,

I started a new thread to address your question here:

RAM requirements for a document

-Rob

ecolomer
Master II
Master II

Here you have an example:

Not applicable
Author

Thank you for posting a sample code. It helped me.