How to get Qlik Alerts throw Mail if Date id modif... - Qlik Community

lakshman1031 · ‎2024-10-17

Hi All,

I have Date field and if date is updated then i want to get alert through mail.

Can any one please suggest me how to set Qlik alert if my data is modified.

Thanks & Regards,

Lakshman

stevedark · ‎2024-10-24

The triggers for the native Qlik alerts is quite limited, you basically need to have a row appear in a table which features on a sheet.

You can use a variable to record the previous date at the start of your load script. You will need to get this with a peek from a QVD, e.g.

tmpLastDate:
LOAD
max(MyDate) as LatestDate
FROM [MyQVD.qvd] (qvd);

let vPriorDate = peek('LatestDate', -1, 'tmpLastDate');

DROP TABLE tmpLastDate;

Then you can do the rest of your load script and write the QVD with new rows, and repeat the code putting the value into vLatestDate.

The table in Sense will want to have a dimension with a fixed string in it, like this:

='The Data Has Changed Since Last Load'

The expression on that can reference your two variables, set in the load script:

=if(vLatestDate <> vPriorDate, 1, 0)

And then set the table to only show non zero values.

You can then set an alert on that chart which will email you.

That is using Sense alerts. I find it better to send the alerts using the SMTP Connector in the load script, and I have a blog post on that here:

Hope that you can work out what you need from that.

Cheers,
Steve

How to get Qlik Alerts throw Mail if Date id modified