topic Re: Qlik Cloud, how to browse Qvd folders dynamically ? in App Development

Qlik Cloud, how to browse Qvd folders dynamically ?

herard_bertrand — Fri, 03 Oct 2025 08:55:31 GMT

Hello,

On Qlik Cloud, I have QVD files stored in subdirectories, themselves located in subdirectories of a data space. Is there a simple script loading syntax to dynamically browse this tree structure to retrieve certain QVDs? Thank you.

Best regards,

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

Daniele_Purrone — Fri, 03 Oct 2025 09:21:29 GMT

Hi @herard_bertrand ,

can you please clarify what you mean?
At which stage do you want to be able to browse the folders? In the data load editor? And what do you mean by "dynamically"?

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

herard_bertrand — Fri, 03 Oct 2025 09:27:49 GMT

Hi 🙂

I try to concatenate QVD with a specific name in data load editor.

By Browsing, in fact I mean to load every qvd with a specific name in a lot of folders and sub folders. By dynamically I mean to do this without knowing the exact name of each folder / subfolders.

Thanks

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

marksouzacosta — Sun, 05 Oct 2025 20:49:17 GMT

Hi @herard_bertrand ,

Yes, you can.

The code below returns every single file in a Space, no matter the subfolder:

For Each vFileName in FileList('lib://DVD Rental Snowflake (DATA-DEV):DataFiles/*') FileList: LOAD '$(vFileName)' AS FileName AutoGenerate(1) ; Next vFileName

You can replace the * with any name pattern, for example:

For Each vFileName in FileList('lib://DVD Rental Snowflake (DATA-DEV):DataFiles/*FILM*') FileList: LOAD '$(vFileName)' AS FileName AutoGenerate(1) ; Next vFileName

Returns

Regards,

Mark Costa

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

herard_bertrand — Mon, 06 Oct 2025 07:35:45 GMT

Thanks 👍

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

110 — Fri, 14 Nov 2025 15:41:19 GMT

Is there a way to bring through file-size also?

I was exploring the API for pulling in the files, but if it's possible to query the file-list directly, this seems much more elegant.

RestConnectorMasterTable:

SQL SELECT

"__KEY_root",

(SELECT

"id",

"folder",

"name",

"baseName",

"size",

"createdDate",

"modifiedDate",

"ownerId",

"qri",

"contentUpdatedDate",

"__KEY_data",

"__FK_data",

(SELECT

"@Value",

"__FK_actions"

FROM "actions" FK "__FK_actions" ArrayValueAlias "@Value")

FROM "data" PK "__KEY_data" FK "__FK_data"),

(SELECT

"__KEY_links",

"__FK_links",

(SELECT

"href",

"__FK_next"

FROM "next" FK "__FK_next"),

(SELECT

"href" AS "href_u0",

"__FK_self"

FROM "self" FK "__FK_self"),

(SELECT

"__FK_prev"

FROM "prev" FK "__FK_prev")

FROM "links" PK "__KEY_links" FK "__FK_links")

FROM JSON (wrap on) "root" PK "__KEY_root";

Re: Qlik Cloud, how to browse Qvd folders dynamically ?

marksouzacosta — Sun, 16 Nov 2025 06:22:31 GMT

Hi @herard_bertrand ,

Definitely!

Using my example above you can add the FileSize function that returns the size in bytes (as well other file functions such as FileTime):

For Each vFileName in FileList('lib://DVD Rental Snowflake (DATA-DEV):DataFiles/*') FileList: LOAD '$(vFileName)' AS FileName, FileSize('$(vFileName)') AS Size AutoGenerate(1) ; Next vFileName

For more details:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFunctions/FileSize.htm

Regards,

Mark Costa