{"id":635,"date":"2021-11-19T17:46:00","date_gmt":"2021-11-19T17:46:00","guid":{"rendered":"https:\/\/eipsoftware.com\/musings\/?p=635"},"modified":"2024-04-14T17:52:16","modified_gmt":"2024-04-14T17:52:16","slug":"visualization-correlation-chart","status":"publish","type":"post","link":"https:\/\/eipsoftware.com\/musings\/visualization-correlation-chart\/","title":{"rendered":"Visualization &#8211; Correlation Chart"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Correlation Chart in Qlik Sense<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Qlik Sense does not have a correlation chart built-in.  However  we can mimic the capability by using a heat map.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;galleryId&quot;:&quot;69dc5ec05eebe&quot;}\" data-wp-interactive=\"core\/gallery\" class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69dc5ec061481&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69dc5ec061481\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" data-id=\"540\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1024x576.jpg\" alt=\"\" class=\"wp-image-540\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1024x576.jpg 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-300x169.jpg 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-768x432.jpg 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1536x864.jpg 1536w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-900x506.jpg 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1280x720.jpg 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69dc5ec061974&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69dc5ec061974\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" data-id=\"541\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1024x576.jpg\" alt=\"\" class=\"wp-image-541\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1024x576.jpg 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-300x169.jpg 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-768x432.jpg 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1536x864.jpg 1536w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-900x506.jpg 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1280x720.jpg 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/figure>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Correlation Chart &#8211; Sample 1<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The first sample shows the MT cars dataset with values  inside the chart.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69dc5ec0624c2&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69dc5ec0624c2\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1024x576.jpg\" alt=\"\" class=\"wp-image-540\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1024x576.jpg 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-300x169.jpg 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-768x432.jpg 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1536x864.jpg 1536w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-900x506.jpg 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01-1280x720.jpg 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_01.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Correlation Chart &#8211; Sample 2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Shows a pivot table of the data, and  the heat map with darker colours representing higher correlation.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69dc5ec0626c7&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69dc5ec0626c7\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1024x576.jpg\" alt=\"\" class=\"wp-image-541\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1024x576.jpg 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-300x169.jpg 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-768x432.jpg 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1536x864.jpg 1536w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-900x506.jpg 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02-1280x720.jpg 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2024\/04\/Correlation_02.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Correlation Chart in Qlik Sense Qlik Sense does not have a correlation chart built-in. However we can mimic the capability by using a heat map.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[42,7],"tags":[39,46,63,64],"series":[],"class_list":["post-635","post","type-post","status-publish","format-standard","hentry","category-visualization-dashboard","category-visualization","tag-visualization","tag-dashboard","tag-qlik","tag-qlik-sense"],"_links":{"self":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":1,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"predecessor-version":[{"id":636,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/635\/revisions\/636"}],"wp:attachment":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/tags?post=635"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/series?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}