Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you please share the sample qvw because not getting the exact issue.
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.