Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor
Partner - Contributor

Loading multiple QVD files in QlikSense Server and Cloud environments.

Hello Qlik Community,

I am trying to write some scripts that I would like to use in some QlikSense apps in both the QlikSense Server environment and in the Qlik Cloud environment. As part of these scripts, I and trying to write find a method to load from multiple QVD files that works in both environments, but I am having trouble finding a solution. Since wildcard loads do not work in the QlikSense Cloud environment, I am trying to use a for each loop with the FileList function to iterate through all QVD files in a data folder, and then use the WildMatch function to define the files that need to be loaded. An example script is below:

LET vRoot = 'lib://Data/';
For Each file In FileList('$(vRoot)')
  If WildMatch('$(file)', '*.qvd') Then
    From [$(file)](qvd);
  End If
Next file

The above script works in the Cloud environment but does not work in the Server environment. After some testing, I found that the Server environment requires '*.qvd' at the end of vRoot or the FileList function will not return any files found. If I add this then the script no longer works in the cloud environment. Does anyone know any workarounds or methods I could use that load from several QVD files in both the Server and Cloud environments?


Labels (1)
1 Reply


In that case, You can use 2 set of code and write the condition based on server/cloud to execute any one. 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.