Adding and managing your analytics data

Add data files and connections from your data sources to your spaces in Qlik Cloud Analytics. You or other users can then use them to add data in apps and scripts.

Apps and scripts require sources of data. Qlik Cloud Analytics supports the following types of data sources:

• Datasets: You can upload data files to Qlik Sense, which are stored in Qlik Cloud. Qlik Sense automatically adds an additional layer of metadata to uploaded data files, creating datasets. You can also create datasets for tables from existing data connections.

  The metadata added to a dataset enables you to use additional Qlik Sense tools for managing your data in the catalog, including catalog tools and other resources. For more information on cataloging, see Understanding your data with catalog tools.

  Qlik Sense supports the following file types:

  • Text files: Data in fields must be separated by delimiters such as commas, tabs, or semicolons. For example: comma-separated variable (CSV) files.

  • HTML tables

  • Excel files

    Information noteYou cannot load data from password-protected Excel files, or Excel Binary Workbook files (.xlsb).

    For more information, see Loading data from Microsoft Excel spreadsheets.

  • XML files

  • Qlik native QVD and QVX files

    For more information, see Working with QVD files.

  • Apache Parquet files

    For more information, see Working with Apache Parquet files.

  • JSON files

    For more information, see Working with JSON files

  • Fixed record length files

  • Data Interchange Format (DIF) files: DIF files can only be loaded with the data load editor.

  • Geographic data files: 

    • GEOJSON

    • ESRIJSON

    • GML

    • KML

    • SHPZIP

    • DXF

  • QlikView script files (QVS)

  For a summary of where in Qlik Cloud you can add different file types as datasets, see Dataset support in Qlik Cloud.

  Data files 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.

• Data connections: Connections allow you to bring data from external data sources, such as databases or remotely stored files, into apps. You can create datasets from connections. For more on supported data sources, see Data sources in Qlik Sense SaaS.

• Data products: You can browse the data marketplace for a data product to use in a new app. Data products are a grouping of multiple datasets, which means you can load a whole set of data related to a common domain in one operation. For more information, see Working with data products

Add datasets and data sources in Create by selecting Dataset, and then selecting Dataset or Connect to data. Once added, they can be managed from Data sources in their space. For more information, see Adding and managing your analytics data.

Datasets and connections can be used in apps with Data manager, Data load editor, or the data catalog. Datasets and connections to data sources can also be added inside an app with Data manager or Data load editor. For information on working with datasets and connections with Data manager, Data load editor, or the data catalog, see:

• Loading data from the data catalog

• Loading and managing data with Data Manager

• Loading and transforming data with scripting

• Loading data from the data marketplace

Datasets and connections can be used in scripts with Script. Datasets and connections to data sources can also be added inside a script in Editor. For more information on working with scripts, see Working with scripts in the catalog.

Datasets and connections to data sources can also be added in Data manager and Data load editor while you are working on an app. For more information, see:

• Adding data to the app from connections and new files

• Using Data load editor

Data and spaces

When you add datasets and connections, you must select a destination space. Spaces are private, such as your personal space, or they are communal spaces with other users, such as shared or managed spaces. Adding data sources to shared or managed spaces allows other users to access your data sources and use them in their own apps. Access to data can be controlled for different space members through space permissions. For more information on spaces, see Working in spaces.

You can manage datasets or connections in a space by clicking Space details and selecting Data files or Connections.

Adding and managing datasets

You can add data files from the Analytics activity center, or from the Data files section when you are managing a space.

For more information, see Adding data files and Managing data files.

Adding and managing data connections

You can create data connections in a number of ways, such as:

• From the Analytics activity center .

• From the Connections section when you are managing a space.

• From the Data load editor or Data manager when working in an app.

For more information, see Adding data connections and Managing data connections.