Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Rob,
This is working fine for me!