{"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\/2022\/04\/Picture1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture2.png\"><img decoding=\"async\" title=\"Picture2.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture3.png\"><img decoding=\"async\" title=\"Picture3.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture4.png\"><img decoding=\"async\" title=\"Picture4.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture5.png\"><img decoding=\"async\" title=\"Picture5.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture6.png\"><img decoding=\"async\" title=\"Picture6.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture7.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture7.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture8.png\"><img decoding=\"async\" title=\"Picture8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture28.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture28.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture9.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture9.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture11.png\"><img decoding=\"async\" title=\"Picture11.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture12.png\"><img decoding=\"async\" title=\"Picture12.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture13.png\"><img decoding=\"async\" title=\"Picture13.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture14.png\"><img decoding=\"async\" title=\"Picture14.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture15.png\"><img decoding=\"async\" title=\"Picture15.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture16.png\"><img decoding=\"async\" title=\"Picture16.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture17.png\"><img decoding=\"async\" title=\"Picture17.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture18.png\"><img decoding=\"async\" title=\"Picture18.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture19.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture19.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture20.png\"><img decoding=\"async\" title=\"Picture20.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture21.png\"><img decoding=\"async\" title=\"Picture21.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture22.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture22.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture23.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Picture23.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture24.png\"><img decoding=\"async\" title=\"Picture24.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture25.png\"><img decoding=\"async\" title=\"Picture25.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture26.png\"><img decoding=\"async\" title=\"Picture26.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/04\/Picture27.png\"><img decoding=\"async\" title=\"Picture27.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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;&nbsp;<\/p>\n","protected":false},"author":17,"featured_media":4525,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4135],"tags":[496,210,550,540],"class_list":["post-4524","post","type-post","status-publish","format-standard","has-post-thumbnail","category-digitalization","tag-bi","tag-business-intelligence","tag-qliksense","tag-qlikview"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>QlikView \u2013 Load data in QlikView \/ QlikSence \u2013 Best practice and trick - dbi services 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;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/e4eb404f9b8f13a19b50021b3eb66065\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2022\\\/04\\\/Picture1.png\",\"keywords\":[\"BI\",\"Business Intelligence\",\"QlikSense\",\"QlikView\"],\"articleSection\":[\"Digitalization\"],\"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 services 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\\\/2022\\\/04\\\/Picture1.png\",\"datePublished\":\"2015-04-14T11:45:00+00:00\",\"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\\\/2022\\\/04\\\/Picture1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/e4eb404f9b8f13a19b50021b3eb66065\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/ALA_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/ALA_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/ALA_web-min-scaled.jpg\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour, part of the Oracle Bern & Zurich team, has more than 20 years of experience in Oracle application development. He specializes in APEX and PL\\\/SQL development, with additional expertise in Java, Oracle WebLogic, and OpenText Documentum middleware. His background also covers business analysis, solution architecture, and service and project management. Prior to dbi services, Alain was Senior Consultant at IMS Health (IQVIA) in Basel and Software Engineer at M&H Informatics. His industry experience covers pharma (including GxP-regulated environments), healthcare, insurance, and banking.\",\"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 services 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;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/Picture1.png","type":"image\/png"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/e4eb404f9b8f13a19b50021b3eb66065"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2022\/04\/Picture1.png","keywords":["BI","Business Intelligence","QlikSense","QlikView"],"articleSection":["Digitalization"],"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 services 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\/2022\/04\/Picture1.png","datePublished":"2015-04-14T11:45:00+00:00","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\/2022\/04\/Picture1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4eb404f9b8f13a19b50021b3eb66065","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/ALA_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/ALA_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/ALA_web-min-scaled.jpg","caption":"Alain Lacour"},"description":"Alain Lacour, part of the Oracle Bern & Zurich team, has more than 20 years of experience in Oracle application development. He specializes in APEX and PL\/SQL development, with additional expertise in Java, Oracle WebLogic, and OpenText Documentum middleware. His background also covers business analysis, solution architecture, and service and project management. Prior to dbi services, Alain was Senior Consultant at IMS Health (IQVIA) in Basel and Software Engineer at M&H Informatics. His industry experience covers pharma (including GxP-regulated environments), healthcare, insurance, and banking.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}