How to Create a QVD File in Qlik Sense

‍

This tutorial shows how to export data from Excel, CSV, or text files into QVD format, which is Qlik Sense's optimized native file format for faster data loading. 

Note: You need a Qlik Sense app with data already loaded from a source like Excel or text files in the Data Load Editor.

1. Login and open the Data Load Editor in your Qlik Sense app and create a new section by clicking the plus icon.
2. Create a new connection by clicking Create new connection and select the folder where your data source is stored.
3. Load your data by clicking on your data source (for example, CSV file or text file) and clicking Insert script to load the data into the editor.
4. In the Data Load Editor, enter a name for the data, for example, Data_Leads.
5. Add a STORE statement to save the data as a QVD file, for example, STORE dataset_name INTO filepath\filename.qvd.
6. Click Load Data to create and save the QVD file.
7. View your QVD file in the folder to verify it is loaded correctly.