Loading data from a file

After you have created your app, you need to load data into it. You can import data from data connections, such as databases, web files, Microsoft Excel spreadsheets, or delimited text files.

Loading data with Add data

The easiest way to load a file is to use Add data You can select data from existing connections, a new data source or Qlik DataMarket.

Do the following:

1. Click Add data.
2. Follow the instructions in the wizard to select data source, data tables and fields.

See: Adding data from files and databases

Loading data using the data load editor

1. In the app overview, click Data load editor.

2. Click ± on a data connection.

   Data connections are displayed in the right-hand side of the data load editor.

   Information noteYou can only see data connections that you own, or have been given access rights to read or update. Please contact your Qlik Sense system administrator to acquire access if required.

3. Select which data file or database to load.

   After selecting a data source, the Select data from dialog is opened.

4. Select tables and fields to load.

5. When you have finished selecting fields, click Load data.

   The Select data from dialog is closed, and the data is imported. The Data load progress dialog shows the results of the data load.

6. When the data load is complete, click Close.

Visualize the data that was loaded

You have now loaded data into the app, and you can start creating sheets and visualizations in the app overview. Click ” and select App overview.

See Adding visualizations.

If you want to verify that your data is loaded, click ” and select Data model viewer. If you used Quick data load you can also import another file to your data model by repeating the Quick data load procedure.