{"id":44798,"date":"2018-12-09T12:50:22","date_gmt":"2018-12-09T07:20:22","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=44798"},"modified":"2018-12-11T11:31:39","modified_gmt":"2018-12-11T06:01:39","slug":"qlik-sense-managing-data","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-managing-data\/","title":{"rendered":"QliK Sense Managing Data – Viewing & Loading"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

Earlier, we discussed Qlik Sense Script Syntax<\/strong><\/a>. Today, we will see Qlik Sense<\/a> <\/strong>Managing Data. In this lesson, we are going to discuss how data is managed in Qlik Sense using various managing tools provided. We will learn about how to add and manage data from the data manager, how to connect to different data sources, and how to load data using the data load script. At last, we will see, how can a user view the entire data structure or data model.<\/span><\/p>\n

So, let’s start Qlik Sense Managing Data Tutorial.<\/p>\n

\"QliK<\/a>

QliK Sense Managing Data – Viewing & Loading<\/p><\/div>\n

2. Qlik Sense Managing Data With the Data Manager<\/span><\/h2>\n

In the explore menu present on the left of the sheet, you get an option called Data manager. Using the data manager, you can add data from different data sources like device files, or Qlik DataMarket or can enter data in the app itself as inline data. After adding data, you can manage the data tables and the associations between them through the data manager.<\/span><\/p>\n

Have a look at Qlik Sense System Functions<\/a><\/strong><\/p>\n

To open the data manager, go to the exploration menu and select the Data manager option. <\/span><\/p>\n

\"Qlik<\/a>

Open Data Manager<\/p><\/div>\n

The data manager opens with the existing loaded tables showing the associations between them at the center. Below the associations section is the preview pane where the contents of the selected table(s) are shown as tables. <\/span><\/p>\n

\"Qlik<\/a>

View Loaded Data Tables<\/p><\/div>\n

You can view loaded data tables or data files in two views, namely, <\/span>Associations<\/b> and <\/span>Tables<\/b>.<\/span><\/p>\n

Do you know about Qlik Sense Selections<\/a><\/strong><\/p>\n

In the associations view, you can see the existing associations between the data tables and edit them as well. The software recommends how good is or will an association between two data tables be. This is indicated by a color-coded recommendation, i.e. green for a strong recommendation, orange for moderate and red for a poor recommendation. You can make associations between table (if they have some fields in common) by dragging the table head towards the another until a bridge between them is made. <\/span><\/p>\n

\"Qlik<\/a>

Make Associations Between Table<\/p><\/div>\n

In the table view, all the data tables are shown separately. <\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Managing Data – Table View<\/p><\/div>\n

Recommended Reading – Qlik Sense Geospatial Function<\/a><\/strong><\/p>\n

a. How to add a Data Table?<\/h3>\n

You can add a new data table in the data manager in two ways.<\/span><\/p>\n