{"id":513,"date":"2016-07-21T13:17:43","date_gmt":"2016-07-21T11:17:43","guid":{"rendered":"https:\/\/innovahead.com\/?p=513"},"modified":"2022-11-02T13:31:29","modified_gmt":"2022-11-02T12:31:29","slug":"improving-qlikview-performance","status":"publish","type":"post","link":"https:\/\/innovahead.com\/es\/improving-qlikview-performance\/","title":{"rendered":"Improving QlikView Performance"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"513\" class=\"elementor elementor-513\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f14d766 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f14d766\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f762860\" data-id=\"f762860\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5aba93e elementor-widget elementor-widget-text-editor\" data-id=\"5aba93e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In this post we will give you some tips to improve the performance in QlikView while developing your application.<\/p><p>These improvements can be done at different levels:<\/p><ul><li>Script<\/li><li>User Interface<\/li><li>Server<\/li><\/ul><p>Find below these <strong>little tips<\/strong> that can make a <strong>big difference<\/strong> in the user experience of your app:<\/p><ul><li><strong><em>Use numbers as key values instead of text<\/em><\/strong><\/li><\/ul><p>When linking between tables using key fields, it is recommendable to use numbers as key values instead of text. \u00a0\u2018Autonumber\u2019 is a useful function to use in this case.<\/p><p>Autonumber (expression [, AutoID])<\/p><p>Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution.<\/p><p><em>Example:<\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-efc41fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"efc41fd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8ae06be\" data-id=\"8ae06be\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bfe7945 elementor-widget__width-initial elementor-widget elementor-widget-shortcode\" data-id=\"bfe7945\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">\n<table id=\"tablepress-3\" class=\"tablepress tablepress-id-3\">\n<thead>\n<tr class=\"row-1\">\n\t<th class=\"column-1\">City<\/th><th class=\"column-2\">Autonumber (City)<\/th>\n<\/tr>\n<\/thead>\n<tbody class=\"row-striping row-hover\">\n<tr class=\"row-2\">\n\t<td class=\"column-1\">Spain<\/td><td class=\"column-2\">1<\/td>\n<\/tr>\n<tr class=\"row-3\">\n\t<td class=\"column-1\">EEUU<\/td><td class=\"column-2\">2<\/td>\n<\/tr>\n<tr class=\"row-4\">\n\t<td class=\"column-1\">Germany<\/td><td class=\"column-2\">3<\/td>\n<\/tr>\n<tr class=\"row-5\">\n\t<td class=\"column-1\">EEUU<\/td><td class=\"column-2\">2<\/td>\n<\/tr>\n<tr class=\"row-6\">\n\t<td class=\"column-1\">Germany<\/td><td class=\"column-2\">3<\/td>\n<\/tr>\n<tr class=\"row-7\">\n\t<td class=\"column-1\">France<\/td><td class=\"column-2\">4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-3 from cache --><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86b4242 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86b4242\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a1c2f3c\" data-id=\"a1c2f3c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-75ffaaa elementor-widget elementor-widget-text-editor\" data-id=\"75ffaaa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li><strong><em>If sorting is not needed, turn it off<\/em><\/strong><\/li><\/ul><p>Especially if fields are evaluated as text they will be sorted as text, which is the slowest sort operation.<\/p><p>If it is necessary sorting text values, you can create in the script a temporary table with the text sorted. After reloaded, you can sort this field in any object by load order, which it is quickly because it does not evaluate the fields.<\/p><ul><li><strong><em>Avoiding resource heavy expressions<\/em><\/strong><\/li><\/ul><p>Replacing them with simpler calculations will help. It is a good practice both in scripting and in objects.<\/p><p>Some of these expressions are:<\/p><ul><li>Count (distinct [FieldName])<\/li><li>If (Condition (Text), &#8230;)<\/li><li>Sum (If (Condition, [FieldName])\u2026)<\/li><li>If (Condition, Sum ([FieldName])\u2026)<\/li><\/ul><p><u>Possible solutions:<\/u><\/p><p>The distinct qualification is costly especially if the field is a string. A useful technique is to assign a value to each new value as the field is read using the \u2018Autonumber\u2019 function.<\/p><p>Create flag fields for those analysis or filters you want to use in the expressions. It is a useful way to improve performance.<\/p><p>Try to use <strong><em>Set Analysis<\/em><\/strong> instead of \u2018IF functions\u2019 in objects expressions.<\/p><ul><li><strong><em>Remove Synthetic Keys<\/em><\/strong><\/li><\/ul><p>Synthetic keys are formed in tables that share more than one field. \u00a0Synthetic keys are anonymous fields that represent all occurring combinations of these shared fields.<\/p><p>When the number of composite keys increases, depending on data amounts, table structure and other factors, QlikView may end up using excessive amount of time and\/or memory Synthetic, so it is better to remove them.<\/p><p>In this case above, SalesOrderNumber and SalesOrderLineNumber are synthetic keys:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a86b710 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a86b710\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-748ba35\" data-id=\"748ba35\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-879e393 elementor-widget elementor-widget-image\" data-id=\"879e393\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"250\" height=\"156\" src=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png\" class=\"attachment-large size-large wp-image-554\" alt=\"\" sizes=\"100vw\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f7d5598 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f7d5598\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a9e5055\" data-id=\"a9e5055\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8672b4d elementor-widget elementor-widget-text-editor\" data-id=\"8672b4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><u>Possible solutions<\/u>: rename fields, remove conflicting fields from one of the two tables, concatenate the tables or create a complex key with the concatenation of all common fields (remember the use of autonumber function for the key values).<\/p><ul><li><strong><em>Use Star Schema as Data Models<\/em><\/strong><\/li><\/ul><p>Star schemas are generally the best solution for fast and flexible QlikView applications.<\/p><ul><li><strong><em>Drop any unnecessary fields<\/em><\/strong><\/li><\/ul><p>An unnecessary field is one which isn\u2019t currently being used. The temporary tables are used in QlikView scripting mostly for doing calculations. These temporary tables should be dropped once when their purpose is achieved.<\/p><p><em>Example:<\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a4b5ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a4b5ad\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fdb2f5d\" data-id=\"fdb2f5d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-32d3929 elementor-widget elementor-widget-image\" data-id=\"32d3929\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"364\" height=\"363\" src=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Capturea.png\" class=\"attachment-large size-large wp-image-558\" alt=\"\" srcset=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Capturea.png 364w, https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Capturea-300x300.png 300w, https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Capturea-150x150.png 150w\" sizes=\"100vw\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8c2822 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8c2822\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-789baa0\" data-id=\"789baa0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9be9986 elementor-widget elementor-widget-text-editor\" data-id=\"9be9986\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li><strong><em>Limit the number of objects <\/em><\/strong><\/li><\/ul><p>Particularly on the same sheet, but overall as well. Memory utilized by the QlikView objects and the calculations time can be monitored from \u2018Memory Statistics\u2019 in the document properties.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bab98e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bab98e3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a2789bd\" data-id=\"a2789bd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-13aeca6 elementor-widget elementor-widget-image\" data-id=\"13aeca6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"683\" height=\"542\" src=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Captureb.png\" class=\"attachment-large size-large wp-image-562\" alt=\"\" srcset=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Captureb.png 683w, https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Captureb-300x238.png 300w, https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Captureb-600x476.png 600w\" sizes=\"100vw\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aab7915 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aab7915\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e721098\" data-id=\"e721098\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5bb9538 elementor-widget elementor-widget-text-editor\" data-id=\"5bb9538\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>On the other hand it is good to know that expressions in charts and tables are only calculated when the object is visible and data changes.<\/p><ul><li><strong><em>Limit the number of text values in a field<\/em><\/strong><\/li><\/ul><p>Break up long strings into separate component fields rather than using one. For example, if you have the complete address in a field you can separate it in different fields like street, city, zip code, etc.<\/p><ul><li><strong><em>Restrict the number of user sessions of one document in QlikView Server<\/em><\/strong><\/li><\/ul><p>This might be used when we have a very large document in our server.<\/p><p>These tips are not universal, each application and requirements are different. But if you are finding performance problems in your application, this post will be a very good start point. \u00a0<\/p><p>Do want to know more about QlikView? Don\u00b4t hesitate to enroll in our courses.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In this post we will give you some tips to improve the performance in QlikView while developing your application. These improvements can be done at different levels: Script User Interface Server Find below these little tips that can make a big difference in the user experience of your app: Use numbers as key values instead &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/innovahead.com\/es\/improving-qlikview-performance\/\" class=\"more-link\">Leer m\u00e1s<span class=\"screen-reader-text\"> \u00abImproving QlikView Performance\u00bb<\/span><\/a><\/p>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[10,15],"class_list":["post-513","post","type-post","status-publish","format-standard","hentry","category-qlik","tag-qlik","tag-qlikview"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Improving QlikView Performance - innovAhead<\/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:\/\/innovahead.com\/es\/improving-qlikview-performance\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improving QlikView Performance - innovAhead\" \/>\n<meta property=\"og:description\" content=\"In this post we will give you some tips to improve the performance in QlikView while developing your application. These improvements can be done at different levels: Script User Interface Server Find below these little tips that can make a big difference in the user experience of your app: Use numbers as key values instead &hellip; Leer m\u00e1s \u00abImproving QlikView Performance\u00bb\" \/>\n<meta property=\"og:url\" content=\"https:\/\/innovahead.com\/es\/improving-qlikview-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"innovAhead\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-21T11:17:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-02T12:31:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png\" \/>\n<meta name=\"author\" content=\"InnovAhead\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"InnovAhead\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/\"},\"author\":{\"name\":\"InnovAhead\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/#\\\/schema\\\/person\\\/311e552ca74a32beab343c5931614bb3\"},\"headline\":\"Improving QlikView Performance\",\"datePublished\":\"2016-07-21T11:17:43+00:00\",\"dateModified\":\"2022-11-02T12:31:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/\"},\"wordCount\":642,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Picture1a.png\",\"keywords\":[\"Qlik\",\"QlikView\"],\"articleSection\":[\"Qlik\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/\",\"url\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/\",\"name\":\"Improving QlikView Performance - innovAhead\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Picture1a.png\",\"datePublished\":\"2016-07-21T11:17:43+00:00\",\"dateModified\":\"2022-11-02T12:31:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Picture1a.png\",\"contentUrl\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Picture1a.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/improving-qlikview-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/innovahead.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Improving QlikView Performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/#website\",\"url\":\"https:\\\/\\\/innovahead.com\\\/\",\"name\":\"innovAhead\",\"description\":\"Business Intelligence, Data Science &amp; CRM\",\"publisher\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/innovahead.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/#organization\",\"name\":\"innovAhead\",\"url\":\"https:\\\/\\\/innovahead.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/cropped-Logo-2023-PNG-2.png\",\"contentUrl\":\"https:\\\/\\\/innovahead.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/cropped-Logo-2023-PNG-2.png\",\"width\":788,\"height\":155,\"caption\":\"innovAhead\"},\"image\":{\"@id\":\"https:\\\/\\\/innovahead.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/innovahead\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/innovahead.com\\\/#\\\/schema\\\/person\\\/311e552ca74a32beab343c5931614bb3\",\"name\":\"InnovAhead\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g\",\"caption\":\"InnovAhead\"},\"url\":\"https:\\\/\\\/innovahead.com\\\/es\\\/author\\\/innovahead\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Improving QlikView Performance - innovAhead","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:\/\/innovahead.com\/es\/improving-qlikview-performance\/","og_locale":"es_ES","og_type":"article","og_title":"Improving QlikView Performance - innovAhead","og_description":"In this post we will give you some tips to improve the performance in QlikView while developing your application. These improvements can be done at different levels: Script User Interface Server Find below these little tips that can make a big difference in the user experience of your app: Use numbers as key values instead &hellip; Leer m\u00e1s \u00abImproving QlikView Performance\u00bb","og_url":"https:\/\/innovahead.com\/es\/improving-qlikview-performance\/","og_site_name":"innovAhead","article_published_time":"2016-07-21T11:17:43+00:00","article_modified_time":"2022-11-02T12:31:29+00:00","og_image":[{"url":"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png","type":"","width":"","height":""}],"author":"InnovAhead","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"InnovAhead","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#article","isPartOf":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/"},"author":{"name":"InnovAhead","@id":"https:\/\/innovahead.com\/#\/schema\/person\/311e552ca74a32beab343c5931614bb3"},"headline":"Improving QlikView Performance","datePublished":"2016-07-21T11:17:43+00:00","dateModified":"2022-11-02T12:31:29+00:00","mainEntityOfPage":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/"},"wordCount":642,"commentCount":0,"publisher":{"@id":"https:\/\/innovahead.com\/#organization"},"image":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png","keywords":["Qlik","QlikView"],"articleSection":["Qlik"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/innovahead.com\/improving-qlikview-performance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/","url":"https:\/\/innovahead.com\/improving-qlikview-performance\/","name":"Improving QlikView Performance - innovAhead","isPartOf":{"@id":"https:\/\/innovahead.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#primaryimage"},"image":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png","datePublished":"2016-07-21T11:17:43+00:00","dateModified":"2022-11-02T12:31:29+00:00","breadcrumb":{"@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/innovahead.com\/improving-qlikview-performance\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#primaryimage","url":"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png","contentUrl":"https:\/\/innovahead.com\/wp-content\/uploads\/2016\/07\/Picture1a.png"},{"@type":"BreadcrumbList","@id":"https:\/\/innovahead.com\/improving-qlikview-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/innovahead.com\/"},{"@type":"ListItem","position":2,"name":"Improving QlikView Performance"}]},{"@type":"WebSite","@id":"https:\/\/innovahead.com\/#website","url":"https:\/\/innovahead.com\/","name":"innovAhead","description":"Business Intelligence, Data Science &amp; CRM","publisher":{"@id":"https:\/\/innovahead.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/innovahead.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/innovahead.com\/#organization","name":"innovAhead","url":"https:\/\/innovahead.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/innovahead.com\/#\/schema\/logo\/image\/","url":"https:\/\/innovahead.com\/wp-content\/uploads\/2023\/03\/cropped-Logo-2023-PNG-2.png","contentUrl":"https:\/\/innovahead.com\/wp-content\/uploads\/2023\/03\/cropped-Logo-2023-PNG-2.png","width":788,"height":155,"caption":"innovAhead"},"image":{"@id":"https:\/\/innovahead.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/innovahead"]},{"@type":"Person","@id":"https:\/\/innovahead.com\/#\/schema\/person\/311e552ca74a32beab343c5931614bb3","name":"InnovAhead","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d25fd197a4abca23149f02415b0137eb1bf28263a100777ee25e7709cb4f8226?s=96&d=mm&r=g","caption":"InnovAhead"},"url":"https:\/\/innovahead.com\/es\/author\/innovahead\/"}]}},"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/posts\/513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":47,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/posts\/513\/revisions\/565"}],"wp:attachment":[{"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/categories?post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/innovahead.com\/es\/wp-json\/wp\/v2\/tags?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}