Viewing 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 change the zoom level by clicking Y, Z or using the slider. Click ü to restore the zoom level to 1:1.

Toolbar

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

Toolbar options
UI item Description

Navigation menu with the following options:

ü App overview

¸ Data manager

Ï Data load editor

ˆ Open hub

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

¨

Menu with the following options:

D Help

] About

Save Save changes.

Show or hide app information, where you can choose to edit app information or open app options and style your app.
t Collapse all tables to show the table name only.
å Reduce the size of all tables to show the table name and all fields with associations to other tables.
s Expand all tables to show all fields.
+ Internal table view - the Qlik Sense data model including synthetic fields.
7 Source table view - the data model of the source data tables.
ì

Layout menu with the following options:

ì Grid layout

ó Auto layout

õ Restore layout

j Open and close the preview pane.

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?