You can add another data file, such as a Microsoft Excel spreadsheet or a comma delimited text file into your app quickly, by clicking Quick data load in the menu.
See: How to prepare Excel files for loading with Qlik Sense
Do the following:
-
Select how to load the data file.
Add data - this will add another data file to the data you have already loaded.
Replace data - this will remove all data you have loaded previously in the app.
Warning noteIf you select Replace data, this can affect visualizations you have created. If the new data does not contain fields with the same names, the visualizations may need to be updated. -
Select which data file to load.
After selecting a file, the Select data from dialog is opened.
- Select tables and fields to load.
-
When you are done selecting fields, click Load data.
The Select data from dialog is closed, and the data is imported. The data load progress dialog provides the results of the data load.
If data was loaded with warnings, see the Troubleshooting section below for more information.
If the app did not contain a sheet, a new sheet is created, which you can start editing to add data visualizations.
Troubleshooting
If you have loaded several files, it is possible that you receive a warning after loading the data. The two most common warnings are:
|
Synthetic keys |
If two tables contain more than one common field, Qlik Sense creates a synthetic key to resolve the linking. See: Synthetic keys |
| Circular references |
If you have loaded more than two tables, the common fields may cause a loop in the data structure. |
Both issues can be resolved in the data load editor.