topic Re: EMail Trigger in QlikView

EMail Trigger

Tue, 07 Jun 2016 15:14:31 GMT

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

Re: EMail Trigger

bindu_apte — Wed, 08 Jun 2016 04:40:08 GMT

Hi,

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

Re: EMail Trigger

tamilarasu — Wed, 08 Jun 2016 05:01:27 GMT

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))

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

Good Luck.