Skip to main content Skip to complementary content

Data manager

You can add, edit and delete data sources easily in the data manager, and then associate the data you added. When you open the data manager, the Associations view is the default view.

Data manager Associations view

A

The toolbar contains the navigation menu, the global menu and other useful commands.

  • : Navigation menu with options App overview, Data load editor, Data model viewer and Open hub.

    Open hub is not shown if the hub has been disabled by your administrator.

  • ¨: Global menu with options Add data, Help and About.
  • Save: Save the app. This button is only available in Qlik Sense Desktop.
  • Tables: You can go to the Tables view to see an overview of the tables in the app.
  • °: Reload all data. The app is automatically saved before loading.

App overview

The hub

Data load editor

Data model viewer

B

In the Associations view of the data manager your data is illustrated using bubbles, with each bubble representing a data table, and the size of the bubble representing the amount of data in the table. The links between the bubbles represent the associations between tables. If it's an association between two tables, you can select the button in the link to view or edit the association.

You can also associate tables automatically according to recommendations by clicking Ñ, and add more tables to your app.

Managing data associations

Adding data to the app

C

You can make changes to an association by selecting another recommendation, or creating a custom association. You can also rename the association.

 

D You can preview the data of the two tables of the association, with the fields used in the association being highlighted.  
E

The bottom row contains actions for selected tables.

  • @: Edit the selected table.
  • ô: Reload the selected table.
  • Ö: Delete the selected table.
  • : Clear data filters.
  • ¥: Concatenate the selected table or view table transformation details.

Managing data in the app with Data manager

Editing a table

Concatenating tables in Data manager

Viewing table and field transformation details in Data manager

F You can undo or redo all operations.  

Data manager Tables view

Information note Data tables defined in the load script are not managed in Data manager. When you add data sources in Data manager, script code will be generated. You can choose to unlock and edit the generated script code, but in that case the data table will not be managed in Data manager anymore.
A

The toolbar contains the navigation menu, the global menu and other useful commands.

  • : Navigation menu with options App overview, Data load editor, Data model viewer and Open hub.

    Open hub is not shown if the hub has been disabled by your administrator.

  • ¨: Global menu with options Add data, Help and About.
  • Save: Save the app. This button is only available in Qlik Sense Desktop.
  • Tables: You can go to the Tables view to see an overview of the tables in the app.
  • °: Reload all data. The app is automatically saved before loading.

App overview

The hub

Data load editor

Data model viewer

B All data tables in the app. You can add data from new or existing data sources, including Qlik DataMarket. You can also edit or remove existing data tables that were added with Data manager. Adding data to the app

Loading data from Qlik DataMarket

C If you select a table you can preview the data in the table.  
D

The bottom row contains actions for selected tables.

  • @: Edit the selected table.
  • ô: Reload the selected table.
  • Ö: Delete the selected table.
  • : Clear data filters.
  • ¥: Concatenate the selected table or view table transformation details.

Managing data in the app with Data manager

Editing a table

Concatenating tables in Data manager

Viewing table and field transformation details in Data manager

E You can undo or redo all operations.  

Table editor

A

The toolbar contains the navigation menu, the global menu and other useful commands.

  • : Navigation menu with options App overview, Data load editor, Data model viewer and Open hub.

    Open hub is not shown if the hub has been disabled by your administrator.

  • ¨: Global menu with options Add data, Help and About.
  • Save: Save the app. This button is only available in Qlik Sense Desktop.
  • Tables: You can go to the Tables view to see an overview of the tables in the app.
  • °: Reload all data. The app is automatically saved before loading.

App overview

The hub

Data load editor

Data model viewer

B With the table editor toolbar you can rename the table, add calculated fields, and update the table from data source. Editing a table
C

You can preview all fields in the selected table. You can also rename the fields and perform other transformations with the field menu (Ô).

You can also change the format of the field data between General, Date and Timestamp.

Fields marked with are used to associate with another table. You can create new associations, and edit existing associations.

 

D The data profiling cards enable you to view summaries for your data and perform transformations on your data.

Assessing table field data before loading data

Replacing field values in a table

Setting field values as null in a table

Customizing the order of dimension values

Splitting a field in a table

Grouping measure data into ranges

E

The bottom row contains actions for selected tables.

  • @: Stop editing the selected table.
  • ô: Reload the selected table.

Managing data in the app with Data manager

Editing a table

F You can undo or redo all operations in the table editor.  

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!