topic Re: Scripting Issue in QlikView

Scripting Issue

Tue, 14 Oct 2014 09:41:36 GMT

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 — Tue, 14 Oct 2014 09:48:53 GMT

See this:

Hope this helps.

Regards

Av7eN

jagan — Tue, 14 Oct 2014 09:50:45 GMT

Hi,

Try like this

Payroll:

LOAD *

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

FROM

FileName.qvd;

Regards,

Jagan.

Tue, 14 Oct 2014 09:53:52 GMT

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)

];

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 — Tue, 14 Oct 2014 09:55:24 GMT

see attached

Regards

Tue, 14 Oct 2014 10:46:18 GMT

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