Alerts Messages

[#1]

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

[rwunderlich · Accepted solution]

To make a file per line, use

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

Concat(FileName, chr(10))

-Rob

[#3]

Thanks heaps Rob.

[bhupesh_gupta]

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