topic Re: Alerts Messages in QlikView

Alerts Messages

Fri, 18 Nov 2011 00:44:41 GMT

G'day QlikView Community;

I have been playing with our very new QV10 set-up which is a lot of fun. I have set up a File Age Monitor QVW (Found on Rob Wunderlich's blog - http://robwunderlich.com/downloads/FileAgeMonitor.zip)

However I have a request to make the message generated by the alert to be a little more readable.

Currently the message code is:

=sum([Is Overdue?]) & ' documents overdue: ' & concat(FileName, ', ')

So when there are multiple QVWs outside of their accepted age parameter, they are just listed and separeted by a comma.

How would I go about separating the file names to be one per line? Is there any decent customisation available for the messages generated by alerts aside from the generic images available in QlikView?

Hope you may be able to assist;

Kieran Boyce

Alerts Messages

rwunderlich — Fri, 18 Nov 2011 03:35:48 GMT

To make a file per line, use

Chr(10) as your separator in the concat function.

Concat(FileName, chr(10))

-Rob

Alerts Messages

Fri, 18 Nov 2011 03:44:06 GMT

Thanks heaps Rob.

Re: Alerts Messages

bhupesh_gupta — Tue, 07 May 2013 10:03:00 GMT

Hi Rob

Please let me know if the File Age Monitor can be used to shoot mails to the intended reciepent in both the cases i.e Successful and failure reload both.

If yes than what code changes are required. and will it work on the version 11 as I am suppose to implement the same in QV 11.

Your help will be highly appreciated

Regards

Bhupesh