Reloadtime and documentname of a QVW

[kris_vliegen]

Hi All,

I would like to create a dashboard with the documentname and reloadtime of our qvw-files.

I've also an excel with the dashboardname and the frequence a dashboard shoul reload.

So we can monitor if a dashboard is created on time or if there is an error or ...

Is it possible to get this data out of a qvw?

This is what I was thinking about.

Hours:
LOAD Customer,
Hours
FROM
[..\..\Mappings\ReloadHours.xlsx]
(ooxml, embedded labels, table is Sheet1);

let noRows = NoOfRows('Hours')-1;

for i=0 to $(noRows)

let vCustomer=peek('Customer',$(i),'Hours');
let vHours=peek('Aantal_Uren',$(i),'Hours');
let vFileLocation = '..\..\' & '$(vCustomer)' & '\04_Documents\';
let vFilename = '..\..\' & '$(vCustomer)' & '\04_Documents\SiteOperations.qvw';
let vReloadTime = qvdCreateTime('$(vFilename)');


FOR each File in filelist ('$(vFileLocation)' & '*.qvw')

Data:
Load
    qvdCreateTime('$(vFilename)') as Reloadtime,
    filename() as fileName,

 '$(vHours) as Hours
1 as Aantal,
*

FROM $(File);

NEXT File ;
next

[rwunderlich · Accepted solution]

If these are server reloaded QVWs, I expect the FileTime would be equal to the ReloadTime().  If you use the FileTime, there is no need to read the actual QVW.  You can do it it like this:

FOR each File in filelist ('$(vFileLocation)' & '*.qvw')
  Data:
  Load
      FileTime('$(File)') as ReloadTime,
      '$(File)' as fileName
  AutoGenerate 1;
NEXT File ;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[kris_vliegen]

Thanks Rob,

This is working fine for me!