{"id":4524,"date":"2015-04-14T13:45:00","date_gmt":"2015-04-14T11:45:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/"},"modified":"2015-04-14T13:45:00","modified_gmt":"2015-04-14T11:45:00","slug":"qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","title":{"rendered":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick"},"content":{"rendered":"<p>In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report.<\/p>\n<h4 style=\"padding-left: 30px;\">1.How to retrieve data in QlikView<\/h4>\n<p><span style=\"line-height: 1.5;\">You have 2 different possibilities to load your data in your report:<\/span><\/p>\n<ul>\n<li>Database connector<\/li>\n<li>File connector<\/li>\n<\/ul>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"Picture1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\" alt=\"Picture1.png\" width=\"450\" height=\"268\" \/><\/a><\/span><\/p>\n<p style=\"padding-left: 30px;\">a) Database connector:<\/p>\n<p>If your data are located in a database, you must use this kind of connectors.<br \/>\nTo connect to a database:<br \/>\nOpen &#8220;Script Editor&#8221;<\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"Picture2.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture2.png\"><img decoding=\"async\" title=\"Picture2.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture2.png\" alt=\"Picture2.png\" \/><\/a><\/span><\/p>\n<p>Click on \u201cTab\u201d and \u201cAdd Tab\u2026\u201d<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture3.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture3.png\"><img decoding=\"async\" title=\"Picture3.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture3.png\" alt=\"Picture3.png\" \/><\/a><\/p>\n<p>Give a name to the new Tab and clock \u201cOK&#8221;<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture4.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture4.png\"><img decoding=\"async\" title=\"Picture4.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture4.png\" alt=\"Picture4.png\" \/><\/a><\/p>\n<p>Select the data source<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture5.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture5.png\"><img decoding=\"async\" title=\"Picture5.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture5.png\" alt=\"Picture5.png\" \/><\/a><\/p>\n<p>Select your connection (for OLE DB, ODBC, connections should be created in the ODBC administrator tool from windows)<br \/>\n<strong>Remark:<\/strong> You can use a special connection on the ETL tool from QlikView named QlikView Expressor<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture6.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture6.png\"><img decoding=\"async\" title=\"Picture6.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture6.png\" alt=\"Picture6.png\" \/><\/a><\/p>\n<p>For this example, I want to connect on a Oracle database:<br \/>\nSelect the connection and click \u201cOK\u201d<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture7.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture7.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture7.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture7.png\" alt=\"Picture7.png\" width=\"336\" height=\"276\" \/><\/a><\/p>\n<p>Select a table (1), than select the fields you want see in your report (2) and click \u201cOK\u201d (3)<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture8.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture8.png\"><img decoding=\"async\" title=\"Picture8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture8.png\" alt=\"Picture8.png\" \/><\/a><\/p>\n<p><strong>TRICK 1:<\/strong> If you use the \u201cConnect\u201d option and you add the User ID and the password in the connection interface, they will be put in the SQL script in an encrypted format<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture28.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture28.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture28.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture28.png\" alt=\"Picture28.png\" width=\"381\" height=\"311\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture9.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture9.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture9.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture9.png\" alt=\"Picture9.png\" width=\"512\" height=\"287\" \/><\/a><\/p>\n<p style=\"text-align: justify; padding-left: 30px;\">\u00a0b) Data file:<\/p>\n<p>You have 4 different options:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture11.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture11.png\"><img decoding=\"async\" title=\"Picture11.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture11.png\" alt=\"Picture11.png\" \/><\/a><\/p>\n<p>(1) Table Files: you can select the following kind of files<\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"Picture12.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture12.png\"><img decoding=\"async\" title=\"Picture12.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture12.png\" alt=\"Picture12.png\" \/><\/a><\/span><\/p>\n<p>(2) QlikView File: You can load .qvw file (QlikView file)<br \/>\n(3) Web File: You can load a file coming from a website<br \/>\n(4) Field data: you can load specific rows coming from a field located in a database<\/p>\n<p>In this example, we select a .qvd file using the 1 option (table file)<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture13.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture13.png\"><img decoding=\"async\" title=\"Picture13.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture13.png\" alt=\"Picture13.png\" \/><\/a><\/p>\n<p>You have 2 options:<br \/>\nClick \u201cNext\u201d and \u201cNext\u201d: you access to the column choose interface<br \/>\n<strong>Remark:<\/strong> To remove a column, click on the cross. Then click \u201cNext \u201d<\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"Picture14.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture14.png\"><img decoding=\"async\" title=\"Picture14.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture14.png\" alt=\"Picture14.png\" \/><\/a><\/span><\/p>\n<p>Check the SQL. If it\u2019s ok, click on \u201cFinish\u201d<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture15.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture15.png\"><img decoding=\"async\" title=\"Picture15.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture15.png\" alt=\"Picture15.png\" \/><\/a><\/p>\n<p>Click on \u201cReload\u201d to load the data<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Picture16.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture16.png\"><img decoding=\"async\" title=\"Picture16.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture16.png\" alt=\"Picture16.png\" \/><\/a><\/p>\n<p><strong>Best Practices:<\/strong> create a variable path<br \/>\nIf you must load data coming from files located in a specific repository, and if this repository is going to change after the report is published in different environments, it is recommended to create a variable to define the folder path.<br \/>\nGo on the Main Tab and create the variable \u201cFilePath\u201d. Don\u2019t forget the \u201c;\u201d at the end<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture17.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture17.png\"><img decoding=\"async\" title=\"Picture17.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture17.png\" alt=\"Picture17.png\" \/><\/a><\/p>\n<p>On the other tab where you load data coming from file located in the same folder, add the variable before the name of the file.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture18.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture18.png\"><img decoding=\"async\" title=\"Picture18.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture18.png\" alt=\"Picture18.png\" \/><\/a><\/p>\n<p>After the deployment on other environment, you just have to update the variable and of course, reload the data.<\/p>\n<h4 style=\"padding-left: 30px;\">2.Optimize the data recovery in QlikView \/ QlickSence<\/h4>\n<p>In this example, some tables are loaded just for one field. We can optimize this schema with using a mapping function. The goal is to limit the number of tables used directly in the schema.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture19.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture19.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture19.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture19.png\" alt=\"Picture19.png\" width=\"501\" height=\"244\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\">Warning: The mapping function can only be used to add one field in a table.<\/span><\/p>\n<p>In our example, we want to add the filed \u201cProduct Group desc\u201d in the table \u201cITEM_MATSER\u201d.<br \/>\nTo create a mapping tab:<br \/>\nAdd a new Tab just after the main tab<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture20.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture20.png\"><img decoding=\"async\" title=\"Picture20.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture20.png\" alt=\"Picture20.png\" \/><\/a><\/p>\n<p>Use the function \u201cMAPPING\u201d in the script as follow:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture21.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture21.png\"><img decoding=\"async\" title=\"Picture21.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture21.png\" alt=\"Picture21.png\" \/><\/a><\/p>\n<p>In the destination table, add the field with the following function \u201cApplymap\u201d as follow:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture22.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture22.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture22.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture22.png\" alt=\"Picture22.png\" width=\"639\" height=\"200\" \/><\/a><\/p>\n<p>(1) Put the name of the Mapping table you have created<br \/>\n(2) Put the name of the key field<br \/>\n(3) Put the name of the field you want to show in your table<\/p>\n<p>Don\u2019t forget to comment the script from your mapped table.<br \/>\nAfter refreshing the data, you will see that the table has disappeared and the filed has been added in the main table.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture23.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture23.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture23.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture23.png\" alt=\"Picture23.png\" width=\"520\" height=\"257\" \/><\/a><\/p>\n<h4 style=\"padding-left: 30px;\">3.How to add a Master Calendar table<\/h4>\n<p>You can generate automatically a master calendar if you need to have all the days located in a period. This calendar will be generated in 3 different steps:<\/p>\n<p style=\"padding-left: 30px;\">a) Creation of the Min \/ Max date temporary table.<\/p>\n<p>Create a new tab and add the following script:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture24.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture24.png\"><img decoding=\"async\" title=\"Picture24.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture24.png\" alt=\"Picture24.png\" \/><\/a><\/p>\n<p style=\"padding-left: 30px;\">\u00a0b) Creation date temporary table.<\/p>\n<p>Add the following script to create a temporary table with all the dates between the MIN and MAX date you have define using the function \u201cAUTOGENERATE\u201d<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture25.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture25.png\"><img decoding=\"async\" title=\"Picture25.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture25.png\" alt=\"Picture25.png\" \/><\/a><\/p>\n<p>Note that we drop the result from the MIN \/ MAX table at the end of the creation from the temporary table.<\/p>\n<p style=\"padding-left: 30px;\">c) Creation Master Calendar table.<\/p>\n<p>After the generation from the temporary table, add the following script to create all the different date fields you need (Year, month, week \u2026)<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture26.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture26.png\"><img decoding=\"async\" title=\"Picture26.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture26.png\" alt=\"Picture26.png\" \/><\/a><\/p>\n<p><strong>Remark:<\/strong> to join your tables, you must give to your new generated field the same name than the field you have used to create your calendar. The result should be like this.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"Picture27.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture27.png\"><img decoding=\"async\" title=\"Picture27.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture27.png\" alt=\"Picture27.png\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">I hope that these best pratices and tricks will help you !<\/p>\n<p><span style=\"text-decoration: underline;\"><strong><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/strong><\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"margin-bottom: 0.0001pt; text-align: justify; text-indent: -18pt; line-height: normal;\"><span style=\"font: 7pt 'Times New Roman';\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri',sans-serif;\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":4525,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[525],"tags":[496,210,550,540],"type_dbi":[],"class_list":["post-4524","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-content-management","tag-bi","tag-business-intelligence","tag-qliksense","tag-qlikview"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick\" \/>\n<meta property=\"og:description\" content=\"In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-14T11:45:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"968\" \/>\n\t<meta property=\"og:image:height\" content=\"578\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick\",\"datePublished\":\"2015-04-14T11:45:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\"},\"wordCount\":781,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\",\"keywords\":[\"BI\",\"Business Intelligence\",\"QlikSense\",\"QlikView\"],\"articleSection\":[\"Enterprise content management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\",\"name\":\"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\",\"datePublished\":\"2015-04-14T11:45:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png\",\"width\":968,\"height\":578},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick - dbi Blog","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:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","og_locale":"en_US","og_type":"article","og_title":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick","og_description":"In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","og_site_name":"dbi Blog","article_published_time":"2015-04-14T11:45:00+00:00","og_image":[{"width":968,"height":578,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png","type":"image\/png"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick","datePublished":"2015-04-14T11:45:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/"},"wordCount":781,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png","keywords":["BI","Business Intelligence","QlikSense","QlikView"],"articleSection":["Enterprise content management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","url":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","name":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png","datePublished":"2015-04-14T11:45:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Picture1.png","width":968,"height":578},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4524"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4524\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4525"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4524"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}