You can upload certain file types and load that data in Data load editor or Data manager.
You can upload datasets directly to spaces in the Analytics activity center. You can also upload datasets to your spaces while working in an app. To add and use a dataset in your app, you must:
- Upload your data files to your cloud. Each data file can be up to 100 GB. However, when uploading very large data files (over 6 GB), you might experience constraints with engine capacity. These constraints are more likely to be encountered with QVD data files due to the memory usage necessary to load QVD files into the engine. For more information about increasing the capacity available, see Large app support.
- Add the data to your app. This is a preliminary step that allows you to select and prepare the data that you want to load.
- Load the data into your app. When you are done selecting and preparing the data, you can load the data into your app. After you load the data, you can use it to create visualizations in your app.
Uploading your data files to your cloud
You can upload data files to your cloud from the DataFiles window. There are different ways to open this window. You can select which space to upload the data files from the spaces drop-down list. You must have editing permission to add data files to a space.
In a new app
Do the following:
- Open the app.
- Click Files and other sources.
- In the left menu, under Existing connections, select the space where you want to upload the file.
- In the left menu, click Data files.
- Under Folder shortcuts, click DataFiles.
- If needed, navigate to the folder within the space where you want to upload the file. Navigate by selecting folders in the list, or type a specific folder path under Path.
- Upload a data file.
In an existing app
Do the following:
- Open the app.
- In the top menu, click
, and then click Files and other sources. - In the left menu, under Existing connections, select the space where you want to upload the file.
- In the left menu, click Data files.
- Under Folder shortcuts, click DataFiles.
- If needed, navigate to the folder within the space where you want to upload the file. Navigate by selecting folders in the list, or type a specific folder path under Path.
- Upload a data file.
In the Data load editor from an existing DataFile connection
Do the following:
- Open the app.
- Open the Data load editor.
-
Go to the Data connections window on the right. You will see folders from personal and shared spaces that you can access.
For datasets in spaces you can access, you can select a space using the drop down menu.
- Choose a DataFiles folder, and click
. -
If you are accessing the DataFiles for a space in Qlik Cloud Analytics, you can navigate to the folder within the space where you want to upload the file. Navigate by selecting folders in the list, or type a specific folder path under Path.
- Upload a data file.
After you have uploaded a file to your cloud, you can add the data to your app, and then load data into your app.
Loading data into your app
Do not add a table in Data manager that has already been added as a scripted table with the same name and same columns in Data load editor.
In Data manager
Do the following:
- Open an app.
-
Open the Data manager, and then click
Add data > Files and other sources. You can also click Add data in in the top bar. Adding data allows you to select and prepare your data before you load the data into your app. - Click Data files.
- In the left menu, under Existing connections, select the space where the file containing your data is located.
- If needed, navigate to the folder within the space where the file is located. Navigate by selecting folders in the list, or type a specific folder path under Path.
- Choose the file that contains your data. Qlik Sense provides you with a preview of your data.
-
Select the tables and fields to load.
-
Click Add data to open the data in the Associations view of the data manager. This allows you to continue to add data sources, transform the data, and associate the tables in Data manager.
Data profiling is enabled by default when you click Add data. Data profiling does the following:
- Recommends data associations.
- Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
- Maps date and time fields to autoCalendar.
Tables are not associated on common field names automatically. You can associate tables in the Associations view.
Tip noteIf you want to load the data directly into your app, click and then disable data profiling. This will also reload all existing data from data sources when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created. -
Click Load data when you are done preparing the data. If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.
If your data includes city or country geographic information, the following QVD files might automatically be added to the current space:
-
countryAliases.qvd
-
countryGeo.qvd
-
cityAliases.qvd
-
cityGeo.qvd
These files are used to provide additional geographic data for the locations included in your added data. Qlik Sense manages and updates these files as necessary. If they are deleted, they are automatically added back after the next reload.
From a data connection in the data load editor
You can go to Data Connections, and use the Select data dialog to select data to load.
For more information, see Selecting data in load scripts.
From a file by writing script code
Files are loaded using a LOAD statement in the script. LOAD statements can include the full set of script expressions. To read in data from another Qlik Sense app, you can use a Binary statement.
For more information, see Load.
Uploading an updated data file
To update data in an app, you can upload an updated data file with the same name as the file you that you previously uploaded. When prompted, choose the replace the previous file. After you have uploaded the data file, you can reload the data into your app.