Skip to main content
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW
Sonja_Bauernfeind
Digital Support
Digital Support

Experience the convenience of a smarter, more efficient file management system today!

We have introduced our new Enhanced File Management feature in Qlik Cloud—making organization effortless. Now you can seamlessly structure your uploaded and cloud-generated files into directories and subdirectories, giving you full control over your data.

With batch actions like move, copy, cut, and paste, managing multiple files has never been easier or faster. Streamline your workflow, reduce clutter, and stay organized with just a few clicks.

Data Structure.png

This feature has been rolled out in the following regions as per:

  • Oct 7th (Mon): SE+JP+UK - 14:00 CET/08:00 ET
  • Oct 9th (Wed): DE+SG+AP - 14:00 CET/08:00 ET
  • Oct 14th (Mon): US - 15:00 CET/09:00 ET
  • Oct 16th (Wed): EU 14:00 CET/08:00 ET 

 

In this blog post we will cover:

 

Where to access the folder structure

The new features are accessible in your Data files menu for each space. 

  1. First, navigate to your Space and click Space Details
  2. Choose Data files

    space details and data files.png

  3. You'll now have access to additional options, such as creating, copying, or deleting folders

    create a new folder.png

Create folder hierarchies and organize files into them

Each space (Personal, Shared, Managed, and Data) in Qlik Cloud Analytics contains its own structure of folders organized in a hierarchical fashion. Data files can be organized in nested folder structures. For example, within your personal space, you might want to have separate folders for Order Data and Budget Data

The location of a file or folder within a space is shown in its path. The path uses / symbols to represent when a folder is nested within other folders. 

For example, suppose within your personal space, you have separate folders for Order Data and Budget Data. If you have a data file named Orders_2024_December.QVD in your Order Data folder, this file would be located in the following folder path within your personal space: 

Personal/Order Data 

 

Perform bulk operations on files and folders

Files and folders can be moved to different spaces or locations within the same space. You can also move multiple items at a time using the Cut and Paste actions, either from the menu or through keyboard shortcuts (CTRL-C, CTRL-V, CTRL-X).

 

Reference space folder structure in Sense app and script development 

LOAD statements in the load script

When you use files in spaces to add data to apps and scripts, the folder location in the space is referenced and required.

Examples: Reference to file at the top-level path of a space

This example loads the file orders.csv from a personal space. The file is not located within any specific folder but sits at the top-level path in the space.

LOAD * FROM [lib://DataFiles/orders.csv]; 

This example loads the file orders.csv from a shared, managed, or data space. The name of the space is TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

LOAD * FROM [lib://TeamSharedSpace:DataFiles/orders.csv]; 

Examples: References to specific folder path within a space

This example loads the file orders_Europe.csv from the folder Orders By Region within a personal space.

LOAD * FROM [lib://DataFiles/Orders By Region/orders_Europe.csv];

This example loads the file orders_Europe.csv from the folder Orders By Region within a shared, managed, or data space. The name of the space is SalesSpace.

LOAD * FROM [lib://SalesSpace:DataFiles/Orders By Region/orders_Europe.csv];

Store statements

When you add a Store statement to store data from a load script into Qlik Cloud Analytics, the folder location in the space is referenced and required.

Example: Storing file at the top-level path of a space

In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the shared space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

Store * from mytable into [lib://TeamSharedSpace:DataFiles/myfile.qvd];

Example: Storing file to a specific folder path within a space

In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the folder SalesData within the space TeamSharedSpace.

Store * from mytable into [lib://TeamSharedSpace:DataFiles/SalesData/myfile.qvd];

Inserting QVS code

When inserting QVS code into a load script, the folder location in the space is referenced and required.

Example: Referencing QVS file at the top-level path of a space

In this example, the file test.qvs is referenced in the load script. The file is located in the space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

$(Must_Include=lib://TeamSharedSpace:DataFiles/test.qvs)

Example: Referencing QVS file in a specific folder path within a space

In this example, the file test.qvs is referenced in the load script. The file is located in the folder SalesData within the space TeamSharedSpace.

$(Must_Include=lib://TeamSharedSpace:DataFiles/SalesData/test.qvs)

 

Documentation

The Qlik Cloud Documentation has been updated with comprehensive information about the new feature.

 

Thank you for choosing Qlik,
Qlik Support

41 Comments
cotiso_hanganu
Partner - Creator III
Partner - Creator III

Tx Qlik R&D for (finally!) making it happen !

Tx @Sonja_Bauernfeind for the update and all the details !

Quick question any chance to add to the script an instruction  to execute a move or a delete file/folder ?

Sempre fi, Cotiso

644 Views
Klaus75
Partner - Contributor II
Partner - Contributor II

@Sonja_Bauernfeind if move and delete instruction would be added to the SaaS Script it should be also added to the EoW / on-prem Scripting. This would be very helpful for automated QVD management in context of archiving and delta management in environments were the task changes are running for years and the customers are tend to not look after the environment ;-).

In the new feature I miss the following points:

- Upload of complete folder structures with files in 1 step

- Upload of ZIP files with folder structures with files which than get extracted / uncompressed in the choosen DataFiles folder

- Integrated basic text editor for QVS, CSV and TXT at least, so that it es possible for example to look in the QVS change for example a view environment settings and connection reference variables to the names defined in the customer tenant. 

This would make the setup of preconfigured / developed complex ETL processes or parametrizied solutions much easier and faster. Important for the partner network related to template-based solution delivery.

 

 

623 Views
MatheusC
Specialist II
Specialist II


@Sonja_Bauernfeind Very good, see the folders and subfolders.

I also noticed that the search for files on the connection is in production, looking forward to this functionality arriving soon.

- Matheus

566 Views
Godek
Contributor II
Contributor II

Great news!

Thanks!

0 Likes
541 Views
DataKnight1
Contributor III
Contributor III

Hi - apologies for asking this, but what are all the abbreviations used on the below - some are obvious, but others not so...thanks;

 

  • Oct 7th (Mon): SE+JP+UK - 14:00 CET/08:00 ET
  • Oct 9th (Wed): DE+SG+AP - 14:00 CET/08:00 ET
  • Oct 14th (Mon): US - 15:00 CET/09:00 ET
  • Oct 16th (Wed): EU 14:00 CET/08:00 ET 
0 Likes
487 Views
Sonja_Bauernfeind
Digital Support
Digital Support

Hello @DataKnight1 

These are the abbreviations for our tenant locations based on the ISO 3166 standard, along with the relevant time zones for the specific release window.

The release dates have all passed since the blog post was released. 

All the best,
Sonja

469 Views
DataKnight1
Contributor III
Contributor III

Thank you for explaining @Sonja_Bauernfeind.  

 

 

0 Likes
443 Views
PrashantSangle

Great!!!..

This is one of the most required features in my list.

2nd on prem folder access through data gateway. 

 

Thanks Qlik Team @Sonja_Bauernfeind 

 

0 Likes
416 Views
agigliotti
Partner - Champion
Partner - Champion

Hi,
I noted there is not the download option yet.
It would be very useful especially for transformed data files.
Best Regards
@Sonja_Bauernfeind 

393 Views
Klaus75
Partner - Contributor II
Partner - Contributor II

@Sonja_Bauernfeind an additional idea to my previous enhancement requests related to the new file management, is Qlik planing or working on the integration of an option to syncronize a local GIT repository with a certain (sub) folder in the new file management of da DataFiles connection?

The point of this feature, which other cloud solution vendors and partners of Qlik 😉 like Snowflake have already implemented, is to have the option to develop QVS Skripts and parameter files (mostly CSV, XSLX, XML) on the local machine and thereore use the prefered development environment (like JetBrains IntelliJ or Webstorm, MS Visual Code or even simple Editors like Notepad++ with Qlik Syntax Highlightning) and the push a certain version to the cloud tenant in a certain connection and sub folder. 

If Qlik would provide a Qlik script language plugin for the JetBrains IDEs as well as Visual Studio Code, maily to support syntax highligthning and check, code completion as well as basic safe refactorings like safe renaming of variables, subs and QVS file names, the development experience would be extremly increased. 

I even started to implement such a plugin on my own for IntelliJ but haven't the time to figure out all the lexer and parser definition for the crappy/inconsistent (compared to other languages) syntax of Qlik script (I know for ~ 15 years and in all details). Qlik should have this already internally and therefore the implementation of such plugins should be no rocket science. 

In addition to that the 2 points above could be the base to go even further and integrate a feature for remote code execution and even debugging. Therefore the plugin could provide the option to generate a temporary app over the REST API, inject the "main" script (which can have includes and reference the already before pushed folder structures from GIT) and trigger the reload with redirection of the log messages to the IDE ... because from my point of view - and I'm 100% sure that hunders of customers, partners, consultants and developer agree with me on that - the Qlik script editor and debugger will never get tot the functional level required and provided from prof. dev. environments.

Would be appreciated if you could push these ideas or topics in Qlik internally to the right person in development because even for me as employee of an Qlik elite partner for 14 years with hundreds of projects it is nearly unpossible to get ideas for enhancement direct to the development team. And the ideation pages in the community doesn't help .. my colleagues and I added many topics years ago and nearly nothing has happend.

348 Views