Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

EMail Trigger

I have a field which is always a text but sometimes we get a numeric field in there. How can I set up a trigger that if I get the Numeric data in that field I get an email

Labels (1)
2 Replies
bindu_apte
Specialist
Specialist

Hi,

Can you please share the sample qvw because not getting the exact issue.

tamilarasu
Champion
Champion

Hi Rehan,

You can use below expression to check whether a specific field contains any numbers or not.

Count(Aggr(If(IsNum(FieldName),1), FieldName))

Capture1.PNG

You can use Alerts option to send an alert mail whenever the count is greater than 0. Have a look at the below link to know more about alerts option.

CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx

Capture.PNG


Good Luck.