<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Set alert in macro in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Set-alert-in-macro/m-p/281607#M104752</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;DIV&gt;Hi Everyone. &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;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 - &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN style="font-size: 8pt;"&gt;&lt;DIV&gt; set FileName&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;= ActiveDocument.Variables ("MyFile")&lt;BR /&gt; set FileDetails = objfso.GetFile (FileName.GetContent.String)&lt;BR /&gt; ActiveDocument.Variables ("Latest Document Date").SetContent FileDetails.DateLastModified, true &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;but unfortunately I got a little lost after this. VB Script is not a strong point for me &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt; &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;Any ideas would be gratefully appreciated. &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;Thanks,&lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;David&lt;/DIV&gt;&lt;SPAN style="font-size: 8pt;"&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 14 Feb 2012 17:51:23 GMT</pubDate>
    <dc:creator>devans_1</dc:creator>
    <dc:date>2012-02-14T17:51:23Z</dc:date>
    <item>
      <title>Set alert in macro</title>
      <link>https://community.qlik.com/t5/QlikView/Set-alert-in-macro/m-p/281607#M104752</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;DIV&gt;Hi Everyone. &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;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 - &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN style="font-size: 8pt;"&gt;&lt;DIV&gt; set FileName&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;= ActiveDocument.Variables ("MyFile")&lt;BR /&gt; set FileDetails = objfso.GetFile (FileName.GetContent.String)&lt;BR /&gt; ActiveDocument.Variables ("Latest Document Date").SetContent FileDetails.DateLastModified, true &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;but unfortunately I got a little lost after this. VB Script is not a strong point for me &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt; &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;Any ideas would be gratefully appreciated. &lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;Thanks,&lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;DIV&gt;David&lt;/DIV&gt;&lt;SPAN style="font-size: 8pt;"&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt; &lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 14 Feb 2012 17:51:23 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Set-alert-in-macro/m-p/281607#M104752</guid>
      <dc:creator>devans_1</dc:creator>
      <dc:date>2012-02-14T17:51:23Z</dc:date>
    </item>
  </channel>
</rss>

