Skip to main content

Reviewing the data model



Reviewing the data model

The data model viewer provides you with an overview of the data structure of the app. You can preview data in the tables and fields in the data model viewer. You can also create dimensions and measures on-the-fly.

The data mode displays the data structure of the app.

Data model viewer.

In the data model viewer, each data table is represented by a box, with the table name as title and with all fields in the table listed. Table associations are shown with lines, with a dotted line indicating a circular reference. When you select a table or a field, the highlighting of associations instantly gives you a picture of how fields and tables are related. You can search for specific tables and fields by clicking Search data model.

You can change the zoom level by clicking zoom in, zoom out or using the slider. Click Home to restore the zoom level to 1:1.


In the data model viewer, you find the following tools in the toolbar at the top of the screen:

Toolbar options
UI item Description

Global menu with navigation options, and actions that you can perform in your app.

For more information about tabbed browsing and the global menu, see Navigating using tabs.


Show or hide app information, where you can choose to edit app information or open app options and style your app.

Prepare your data. You can select Data manager, Data model viewer, or Data load editor.

The options are not available in a published app, unless you are the owner of the app. In that case, you can only open the Data model viewer.


Analyze your data. You can select Sheet or Insights.


Tell a story with your data. You can select Storytelling.

Save Save changes (Qlik Sense Desktop).
Collapse Collapse all tables to show the table name only.
Reduce Reduce the size of all tables to show the table name and all fields with associations to other tables.
Expand Expand all tables to show all fields.
Scatter chart Internal table view - the Qlik Sense data model including synthetic fields.
Data model Source table view - the data model of the source data tables.
Grid View

Layout menu with the following options:

Grid View Grid layout

auto Auto layout

Time Restore layout

open bottom panel Open and close the preview pane.

For more information, see Preview of tables and fields in the data model viewer.