Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

manuoreguy
New Contributor II

QlikSense Script New Function

Hi,

I'm trying to create a script that does the following:

  • I have 10 QVD's in one folder.

  • I want a script that read's them all and do a table with the name of the file.qvd in one column and the last modification or reload time in another column.

  • I need to know which QVD is not reloading, without having to look at the folder

Please, i will wait for an answer.

Thank's,

Manu

1 Solution

Accepted Solutions
adityaakshaya
Contributor III

Re: QlikSense Script New Function

Hi Juan,

I hope all the qvds are in the same folder.

You can use below script to address your problem.

Let vPath= 'C:\'

Load *,

Filename() as Filename,

FileTime() as Filetime

From [$(vPath)*.qvd(qvd)];

Regards,

Akshaya

PS - If you find the response helpful/correct, mark it helpful or correct.

3 Replies
adityaakshaya
Contributor III

Re: QlikSense Script New Function

Hi Juan,

I hope all the qvds are in the same folder.

You can use below script to address your problem.

Let vPath= 'C:\'

Load *,

Filename() as Filename,

FileTime() as Filetime

From [$(vPath)*.qvd(qvd)];

Regards,

Akshaya

PS - If you find the response helpful/correct, mark it helpful or correct.

manuoreguy
New Contributor II

Re: QlikSense Script New Function

Thanks, that worked

adityaakshaya
Contributor III

Re: QlikSense Script New Function

Can you mark the response as correct and close this thread.

Regards,

Akshaya