{"id":39021,"date":"2018-11-07T09:45:23","date_gmt":"2018-11-07T04:15:23","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=39021"},"modified":"2018-11-13T17:08:56","modified_gmt":"2018-11-13T11:38:56","slug":"qlik-sense-data-model","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/","title":{"rendered":"Qlik Sense Data Model | Associations in Qlik Sense"},"content":{"rendered":"

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

Earlier we saw Qlik Sense System Requirements<\/a><\/strong>. Today, we will see the Qlik Sense Data Model.\u00a0Moreover, we will look\u00a0at how to make associations in Qlik Sense. So, a<\/span>s the associative model is not an unfamiliar term for us, it will be easier for us to walk through this lesson. In this tutorial, we will learn how the data association works in Qlik Sense and how to manually make associations between tables you load in Qlik Sense.\u00a0<\/span><\/p>\n

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

\"Qlik<\/a>

Qlik Sense Data Model | Associations in Qlik Sense<\/p><\/div>\n

2. Qlik Sense Data Model <\/span><\/h2>\n

The associative model powered by the QIX engine of Qlik Sense makes data discovery and analysis a very easy task in the BI tools<\/a><\/strong>. Basically, through these associations between data tables, we make a logical connection, by linking relevant data fields and data values with one another. When all the relevant data residing in the entire data set link with one another. Then it forms a logical structure of data and gives it some meaning.<\/span><\/p>\n

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

Now, when you use different fields and data values to create visualizations on the sheet, you would obviously not do that to only watch the visualizations idly. You would want them to be responsive and interactive. This interactive nature is achieved by the associative selection data model, where the software reacts or responds in a suitable way upon making a selection. In the following sections, we will learn ways to make your data tables interactive and dynamic ensuring better results of data analysis. <\/span><\/p>\n

3. How to Make Associations in Qlik Sense?<\/span><\/h2>\n

In order to make an association between data tables, let us suppose that we have two tables already loaded in Qlik Sense. The two tables are named <\/span>Product Records<\/span><\/i> and <\/span>Order Details<\/span><\/i> which are sample tables used by us. Now, we want to add a third table named <\/span>Sales Record<\/span><\/i>. So, we will open Qlik Sense, open the app which contains the two tables and we want to add the third in. Click on <\/span>Edit<\/b> option from the toolbar of the sheet. <\/span><\/p>\n

Open the Global Menu and select Add Data option. This will add the third table. Select the data file from the source is located in your system and click on <\/span>Add Data <\/b>button<\/span>. <\/b><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Associations<\/p><\/div>\n

Have a look at Qlik Sense Selections Visualizations<\/a><\/strong><\/p>\n

\"Qlik<\/a>

Data Model in Qlik Sense – Associations<\/p><\/div>\n

\"Qlik<\/a>

Qlik Sense Data Model – Association in Qlik Sense<\/p><\/div>\n

This will load the table and automatically show the tables as bubbles in the Data Manager. Notice the Recommended associations section present at the right side which shows the system recommended associations. In our sample, the recommended association is between the tables <\/span>ProductRecord<\/span><\/i> and <\/span>SalesRecord<\/span><\/i>, because these tables must have one or two fields in common.<\/span><\/p>\n

Let’s discuss Qlik Sense Filter Pane<\/a><\/strong><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Tables as Bubbles<\/p><\/div>\n

To make the recommended association, click and hold on one of the recommended tables and drag it towards the other. This will create an association between the two tables as soon as you release the mouse button. This newly formed association is shown by a grey bridge made between the bubbles (representing tables). Also, the bar given right beneath the association display pane shows a button at the center having the name of the common field between the two tables (Product<\/span>_Id) with a green dot (representing a strong recommendation or is a sign of good data structure). On either side of this button are the names of the two associated tables. The section below this displays the contents of each table, with a long green bar on those fields which are common between the two tables.<\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Association Between Two Table<\/p><\/div>\n

Know more about Qlik Sense Histogram Visualization<\/a><\/strong><\/p>\n

Similarly, you can keep on adding more tables from the plus sign given at the top left corner of the display panel and associate them with relevant tables using the recommendations. However, if you try to make a connection or association which is not recommended by the system\u2019s logic and potentially distorts the good data structure. Such an association is represented in red. <\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Adding More tables<\/p><\/div>\n

\"Qlik<\/a>

Qlik Sense Data Model – Association using Recommendation<\/p><\/div>\n

Let’s discuss Qlik Sense Text and Image Visualizations<\/a><\/strong><\/p>\n

\"Qlik<\/a>

Data Model in Qlik Sense – Make a Connection<\/p><\/div>\n

We can make associations in one more way, i.e. recommend mildly or moderately recommended. Such associations represented by the color orange. <\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Moderately recommendation<\/p><\/div>\n

Know more about Qlik Sense Gauge Chart<\/a><\/strong><\/p>\n

\"Qlik<\/a>

Qlik Sense Data Model – Association representing in Orange<\/p><\/div>\n

Click on <\/span>Load Data<\/b> button present at the top right corner of the editor to confirm the associations you made and work with data and visualizations on the sheet.<\/span><\/p>\n

You must read Qlik Sense Box Plot<\/a><\/strong><\/p>\n

So, this was all in Qlik Sense Associative Data Model. Hope you like our explanation.<\/p>\n

4. Conclusion<\/span><\/h2>\n

Hence, this was all about the associative data model in Qlik Sense. Moreover, creating an association is a great way of framing an efficient Qlik Sense Data Model for your application. Also, the importance of a well-structured data model is evident as it ensures proper functioning and behavior data. So, it also maintains the data processing speed and manages data storage well.<\/span><\/p>\n

Still, if you want to ask any question related to Qlik Sense Data Model, ask in the comment tab.<\/p>\n

See also –\u00a0<\/strong><\/p>\n

Qlik Sense Treemap Visualization<\/a><\/strong><\/p>\n

Reference for Qlik Sense<\/strong><\/a>

1. Objective Earlier we saw Qlik Sense System Requirements. Today, we will see the Qlik Sense Data Model.\u00a0Moreover, we will look\u00a0at how to make associations in Qlik Sense. So, as the associative model is...<\/p>\n","protected":false},"author":6,"featured_media":39042,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17445,17444,17446,17443],"class_list":["post-39021","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-associative-data-model-in-qlik-sense","tag-data-model-in-qlik-sense","tag-making-association-in-qlik-sense","tag-qlik-sense-data-model"],"yoast_head":"\nQlik Sense Data Model | Associations in Qlik Sense - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense data model - How to make Associations in Qlik sense, Data Model in Qlik sense, Steps to make Qlik Sense associations, Qlik Sense Structured Model\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Data Model | Associations in Qlik Sense - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense data model - How to make Associations in Qlik sense, Data Model in Qlik sense, Steps to make Qlik Sense associations, Qlik Sense Structured Model\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-07T04:15:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T11:38:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1204\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Data Model | Associations in Qlik Sense - DataFlair","description":"Qlik Sense data model - How to make Associations in Qlik sense, Data Model in Qlik sense, Steps to make Qlik Sense associations, Qlik Sense Structured Model","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Data Model | Associations in Qlik Sense - DataFlair","og_description":"Qlik Sense data model - How to make Associations in Qlik sense, Data Model in Qlik sense, Steps to make Qlik Sense associations, Qlik Sense Structured Model","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-07T04:15:23+00:00","article_modified_time":"2018-11-13T11:38:56+00:00","og_image":[{"width":1204,"height":629,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Data Model | Associations in Qlik Sense","datePublished":"2018-11-07T04:15:23+00:00","dateModified":"2018-11-13T11:38:56+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/"},"wordCount":1016,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg","keywords":["Associative Data Model in Qlik Sense","Data Model in Qlik Sense","Making Association in Qlik Sense","qlik sense data model"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/","name":"Qlik Sense Data Model | Associations in Qlik Sense - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg","datePublished":"2018-11-07T04:15:23+00:00","dateModified":"2018-11-13T11:38:56+00:00","description":"Qlik Sense data model - How to make Associations in Qlik sense, Data Model in Qlik sense, Steps to make Qlik Sense associations, Qlik Sense Structured Model","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlik-Sense-Data-Model-01.jpg","width":1204,"height":629,"caption":"Qlik Sense Data Model | Associations in Qlik Sense"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-data-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Data Model | Associations in Qlik Sense"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=39021"}],"version-history":[{"count":9,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39021\/revisions"}],"predecessor-version":[{"id":41872,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/39021\/revisions\/41872"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/39042"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=39021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=39021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=39021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}