Scripting Issue

[#1]

Hi,

I have a folder in which there are various qvd files.

On my dashboard, i wish to show the last refresh time of various qvds.

Please help.....

[aveeeeeee7en]

See this:

http://community.qlik.com/thread/136717

Hope this helps.

Regards

Av7eN

[jagan]

Hi,

Try like this

Payroll:

LOAD *

     QvdCreateTime(FileDir() & '\'&FileName()) as LastRefreshTime

FROM

FileName.qvd;

Regards,

Jagan.

[#4]

Hi Asma,

you can use the below sript.

for each v_qvd in 'c:\QVD\*.qvd (replace with qvd path)

let vTime=QvdCreateTime($(v_qvd);

QVD_Time:

Load * inline[time, QVD

$(vTime),$(v_qvd)

];

next

Table QVD_Time contains the list of QVD with the refresh time.

This is to get the latest refreshed qvd if you need

LatestQVD:

Load Max(time) as MaxTime,QVD

resident QVD_Time;

letv_latestQVD=peek(MaxTime,'LatestQVD');

[martinpohl · Accepted solution]

see attached

Regards

[#6]

Thanks everyone for such a quick response!!!!!