Skip to main content
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

2 Replies
bindu_apte
Creator III
Creator III

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.