Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
devans_1
Creator
Creator

Set alert in macro

Hi Everyone.
I am trying to flag when a new version of a document is available (the document runs every hour or so in background). It would be nice to have an alert pop up to the users viewing the document via the user access point when this happens. I can set up a post-reload alert which pops up correctly when I run the document in the development area but fails in the user area (unless the user refreshes the document which defeats the purpose). Does anyone know if what I am trying to achieve is possible ? Failing this, is it possible to do this in a macro ? The idea is to check the date of the qvd and send an alert when this changes. I started this -
set FileName     = ActiveDocument.Variables ("MyFile")
set FileDetails = objfso.GetFile (FileName.GetContent.String)
ActiveDocument.Variables ("Latest Document Date").SetContent FileDetails.DateLastModified, true
but unfortunately I got a little lost after this. VB Script is not a strong point for me
Any ideas would be gratefully appreciated.
Thanks,
David
0 Replies