Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manuoreguy
Partner - Contributor II
Partner - 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
Creator III
Creator III

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.

View solution in original post

3 Replies
adityaakshaya
Creator III
Creator III

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
Partner - Contributor II
Partner - Contributor II
Author

Thanks, that worked

adityaakshaya
Creator III
Creator III

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

Regards,

Akshaya