Skip to main content

Adding data

Your second step towards a complete app is associating and then loading the data. You will load the following files:

  • Sales.xlsx

  • Item master.xlsx

  • Cities.xlsx

  • Sales rep.csv

  • Customers.xlsx

Associating data

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. Bubbles marked with * indicates a new or updated table. You should see five data tables.

Now it is time to create an association between the fields in your tables Sales and Sales rep.

Do the following:

  1. Drag the Sales rep bubble towards the Sales bubble.

    Qlik Sense now detects a fairly recommended association to the Sales table and its bubble is marked with orange.

  2. Drop the Sales rep bubble onto the Sales bubble.

    A link is now created between the bubbles and the tables are associated using the recommended fields.

  3. Click the link between the Sales rep bubble and the Sales bubble.

    The association panel, at the bottom of the screen, displays a preview of data in the associated fields.

  4. Click the association Sales rep ID-Sales Rep Number in the association panel and rename it Sales Rep Number.
  5. The association is now named Sales Rep Number.

Now you have associated the first two tables. The next step is to associate more tables.

Adding and associating more data

You have already associated the tables Sales and Sales rep. Qlik Sense helps you identify recommended associations and you will now explore this.

In the Associations view, do the following:

  1. Click and hold the bubble Customer.

    The bubbles Sales and Cities are marked green because Qlik Sense highly suggests associating these two tables to Customers.

  2. Click and hold the bubble Cities.

    The bubble Customer is marked green. The bubble Sales is marked orange, which indicates a medium recommendation.

  3. Click and hold the bubble Item master.

    The bubble Sales is marked green.

Recommended associations are identified between all tables and you will now let Qlik Sense create the associations for you.

Do the following:

    1. Make sure the Recommend associations tab is opened by clicking Ñ.

    2. Click Apply all..

      The tables are now associated according to Qlik Sense recommendations.

      The associations between the five tables indicated by links between their respective bubbles

All tables are now associated and you will now load the data.

Loading data

Now you have added all data files and associated their tables. Before you start building your app you must load the script.

Do the following:

  1. Click Load data.

    A progress window is displayed while the data is loading. When the data load is complete, you can continue.

  2. Click Close.

Viewing the data model

Now you are ready to start building your app, but before you start, let's have a look at the data model.

Do the following:

  1. In the toolbar, click the Prepare sub-menu , and select Data model viewer.
  2. In the toolbar in the data model viewer, click s to expand the tables.

All tables are now connected and the data model viewer should have the following content. A field connecting one or more tables is called a key.

The data model viewer with tables connected using key fields

You have now finished adding data and can start building your app.