QlikView App: Send Data In QlikView Alerts

[stevedark]

This example has been produced to accompany the blog post Sending Data In QlikView Alerts

There is a Qlik Sense version of this solution here: https://www.quickintelligence.co.uk/send-data-from-qlik-load-script/

This application demonstrates how alerts e-mails can be sent when a certain criteria is met.  It also takes this concept further by showing how the CONCAT and AGGR statements can be used to construct a string from a number of expressions, which can then be used as the body of the email.

The blog article gives further details and explanation on how this works and how to implement it in your own applications.

Please also see my other uploaded Qlik apps and tutorials https://www.quickintelligence.co.uk/examples/

Steve Dark

https://www.quickintelligence.co.uk/

[stevedark]

Hi @KishoreSuri 

What you will need to do is write out from each of the individual loads on completion and then have an app that looks at the completion status from all the apps.

The simplest way to do this will be to store the status into a Text file. Something like this:

ReloadDone:
LOAD
'Complete' as ReloadStatus,
Date(now(), 'YYYYMMDDhhmm') as ReloadDate
AUTOGENERATE(1);
STORE ReloadDone INTO [c:\ReloadStatus\Reload_Step1.txt] (txt);
DROP TABLE ReloadDone;

You will then have a folder of files which you can check. You can then load from all of those files to check that all reload dates are in the current day and all reload status are Complete. You could add similar store statements throughout the loads, to update on progress, so you would have a single app that could check the status of multiple loads.

To load the status of all the loads you can do a wildcard load:

Status:
LOAD
ReloadStatus,
Date(Date#(ReloadDate, 'YYYYMMDDhhmm'), 'DD MMM YYYY hh:mm') as ReloadDate
FROM [c:\ReloadStatus\Reload_Step*.txt] (txt);

You can then do an alert in QlikView in the normal way.

Or, you may want to look at this post which describes sending from the load script using Qlik Web Connectors:

https://www.quickintelligence.co.uk/send-data-from-qlik-load-script/

Be aware there is a slight syntax change between Sense and QlikView for writing files out.

Good luck!

Steve

[KishoreSuri]

Hi Steve,

Thanks, It may help us.

Kishore S