Domain > blog.ipponservices.com

More information on this domain is in AlienVault OTX

Whois

Property	Value
NameServer	NS76.DOMAINCONTROL.COM
Created	2011-05-11 00:00:00
Changed	2013-05-12 00:00:00
Expires	2015-05-11 00:00:00
Registrar	GODADDY.COM, LLC

DNS Resolutions

Date	IP Address
2014-03-28	66.6.40.75 (ClassC)
2014-03-30	66.6.40.74 (ClassC)
2014-12-08	66.6.42.22 (ClassC)
2024-11-16	74.114.154.18 (ClassC)

HTTP/1.1 200 OKServer: nginxDate: Sat, 16 Nov 2024 09:50:41 GMTContent-Type: text/html; charsetUTF-8Content-Length: 167276Connection: keep-aliveVary: Accept-EncodingX-Rid: 73c1f65aaaaf09afa88bb57728559ae3P3p: CPTumblrs privacy policy is available here: https://www.tumblr.com/policy/en/privacyX-Xss-Protection: 1; modeblockX-Content-Type-Options: nosniffStrict-Transport-Security: max-age15552001X-Tumblr-User: ipponservicesX-Tumblr-Pixel-0: https://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoidXJsIiwidXJsIjoiaHR0cDovL2Jsb2cuaXBwb25zZXJ2aWNlcy5jb20vIiwicmVxdHlwZSI6MCwicm91dGUiOiIvIn0&UHIJHCFAAFO&Kdc59ebd3f5becd1c6e81f66ca12433edbeaf0c5d52f67cec588c6d3809b22328--https://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoicG9zdCIsInVybCI6Imh0dHA6Ly9ibG9nLmlwcG9uc2VydmljZXMuY29tLyIsInJlcXR5cGUiOjAsInJvdXRlIjoiLyIsInBvc3RzIjpbeyJwb3N0aWQiOiIxNDE0ODc0NzQwODciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6X-Tumblr-Pixel-1: IjE0MTIwNTYyODI2MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQxMDMwNzM5Nzc3IiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDA4NDY3Nzc2MTciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjE0MDQ0MjAxOTk0MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQwMzQwMzY0MDYyIiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDAyMDg5MDQ1NDIiLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjMxNTE3NDI2NDAxIiwiYmxvZ2lkIjo0NzM5OTc3NCX-Tumblr-Pixel-2: wic291cmNlIjozM30seyJwb3N0aWQiOiIyOTg5Nzg5OTA0MyIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMjk4ODkyOTA2NjciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfV19&ULCGGJJFDFG&K8884a038f8f55df220c8dfe885e3e3f16f82b23da3d442a07ceb88b7b7d406feX-Tumblr-Pixel: 3Link: https://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj>; reliconX-UA-Compatible: IEEdge,chrome1X-UA-Device: desktopVary: X-UA-Device, Accept, Accept-EncodingAccept-Ranges: bytesx-a8cblr: 1X-nc: MISS

!DOCTYPE html>script>var __pbpa  true;/script>script>var translated_warning_string  Warning: Never enter your Tumblr password unless \u201chttps://www.tumblr.com/login\u201d\x0ais the address in your web browser.\x0a\x0aYou should also see a green \u201cTumblr, Inc.\u201d identification in the address bar.\x0a\x0aSpammers and other bad guys use fake forms to steal passwords.\x0a\x0aTumblr will never ask you to log in from a user\u2019s blog.\x0a\x0aAre you absolutely sure you want to continue?;/script>script typetext/javascript languagejavascript srchttps://assets.tumblr.com/assets/scripts/pre_tumblelog.js?_vb9f848c06fcba7eaf305d4a7cb7a1b98>/script>!DOCTYPE html>!--if IE 8>html classlt-ie10 lt-ie9> !endif-->!--if IE 9>html classlt-ie10> !endif-->!--if gt IE 9>!--> html> !--!endif-->    head prefixog: http://ogp.me/ns# fb: http://ogp.me/ns/fb# blog: http://ogp.me/ns/blog#>                meta charsetutf-8>        title>IPPON Qlikview Blog/title>        meta namedescription contentNikolas Daley is a director of Qlikview consultants Ippon Services specialising in Business Intelligence software development for the finance industry. The software we develop aims to deliver...>                meta nameviewport contentwidthdevice-width, initial-scale1.0, maximum-scale1.0, user-scalableno>        meta nametheme-color content#35465D>        style>figure{margin:0}.tmblr-iframe{position:absolute}.tmblr-iframe.hide{display:none}.tmblr-iframe--amp-cta-button{visibility:hidden;position:fixed;bottom:10px;left:50%;transform:translateX(-50%);z-index:100}.tmblr-iframe--amp-cta-button.tmblr-iframe--loaded{visibility:visible;animation:iframe-app-cta-transition .2s ease-out}/style>link relstylesheet mediascreen hrefhttps://assets.tumblr.com/client/prod/standalone/blog-network-npf/index.build.css?_vf085dde138e244526309d4673db67b4c>link relshortcut icon hrefhttps://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj>        link relapple-touch-icon-precomposed hrefhttps://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj>        link relalternate typeapplication/rss+xml hrefhttps://blog.ipponservices.com/rss>        link relstylesheet hrefhttps://assets.tumblr.com/default-theme/r1/main-min.css>                        !-- HTML5 Shiv -->        !--if lt IE 9>            script srchttps://static.tumblr.com/hriofhd/Qj0m8pn7q/html5shiv.js>/script>        !endif-->        style>            /* Colors */            body {                background: #FAFAFA;            }            .blog-title {                font-family: Gibson, sans-serif, Helvetica Neue, HelveticaNeue, Arial, sans-serif;                font-weight: bold;            }            .blog-title a,            .description,            .search-no-results,            .likes-no-likes,            .related-posts-wrapper > h2,            .loader .loader-bar,            .widget-title,            .tagged-page-cta .tagged-page-cta-desc {                color: #444444;            }            .tagged-page-cta .tagged-page-cta-tag {                color: #444444;                border-color: #444444;            }            a {                color: #529ECC;            }            #pagination a,            .nav-wrapper .nav-item .label {                color: #529ECC;            }            #pagination a.next:after {                border-left-color: #529ECC;            }            #pagination a.previous:after {                border-right-color: #529ECC;            }            .header-image.cover {                background-image: url(https://static.tumblr.com/3b975cedd10907468133305a34b37162/zcdpezf/UCZo3icm0/tumblr_static_6kbnzikxf64ocsc0480gcog8s_2048_v2.png);            }            .user-avatar {                background-color: #FAFAFA;                border-color: #FAFAFA;            }            .avatar-style-square .user-avatar {                -webkit-box-shadow: 0 0 0 4px #FAFAFA;                box-shadow: 0 0 0 4px #FAFAFA;            }            .no-header-image .logo-wrapper,            .contain-header-image .logo-wrapper {                color: #529ECC;            }            /* Adjust logo for light accents on light backgrounds */            .light-on-light.no-header-image .logo-wrapper,            .light-on-light.contain-header-image .logo-wrapper {                color: #444;            }            /* Adjust logo for dark accents on dark backgrounds */            .dark-on-dark.no-header-image .logo-wrapper,            .dark-on-dark.contain-header-image .logo-wrapper {                color: #fff;            }            /* Logged-out compact Tumblr iframe */            .tmblr-iframe-compact .tmblr-iframe--unified-controls {                min-width: 100%;                background-color: #FAFAFA;            }            /* Sticky nav colors */            .nav-fixed {                background-color: #FAFAFA;            }            .nav-responsive .inline-nav::after {                background-image: linear-gradient(left, rgba(250,250,250, 0) 0%, rgba(250,250,250,1) 100%);                background-image: -webkit-linear-gradient(left, rgba(250,250,250, 0) 0%, rgba(250,250,250,1) 100%);                background-image: -moz-linear-gradient(left, rgba(250,250,250, 0) 0%, rgba(250,250,250,1) 100%);                background-image: -ms-linear-gradient(left, rgba(250,250,250, 0) 0%, rgba(250,250,250,1) 100%);                background-image: -o-linear-gradient(left, rgba(250,250,250, 0) 0%, rgba(250,250,250,1) 100%);            }            @media screen and (max-device-width: 568px) {                .header-image.cover {                    background-image: url(https://static.tumblr.com/3b975cedd10907468133305a34b37162/zcdpezf/UCZo3icm0/tumblr_static_6kbnzikxf64ocsc0480gcog8s_640_v2.png);                    -webkit-background-size: cover;                    background-size: cover;                }                .avatar-style-square .user-avatar {                    -webkit-box-shadow: 0 0 0 3px #FAFAFA;                    -moz-box-shadow: 0 0 0 3px #FAFAFA;                    box-shadow: 0 0 0 3px #FAFAFA;                }            }            /* Custom CSS */                    /style>    link relalternate hrefandroid-app://com.tumblr/tumblr/x-callback-url/blog?blogNameipponservices />link relalternate hrefios-app://305343404/tumblr/x-callback-url/blog?blogNameipponservices />script    defer    typeapplication/javascript    idbilmur    data-providertumblr.com    data-serviceblognetwork    data-customproperties{theme: tumblrofficial}    nonce3dBCnSk5hAwhQ40bOXcHTqzQ9EY    srchttps://s0.wp.com/wp-content/js/bilmur.min.js?m202446  >/script>script srchttps://assets.tumblr.com/assets/scripts/tumblelog_post_message_queue.js?_va8fadfa499d8cb7c3f8eefdf0b1adfdd>/script>link relstylesheet typetext/css hrefhttps://assets.tumblr.com/fonts/gibson/stylesheet.css?v3>meta namekeywords contentqlikview,business intelligence,kimball,dimensional models,qliksense />!-- BEGIN TUMBLR FACEBOOK OPENGRAPH TAGS -->!-- If youd like to specify your own Open Graph tags, define the og:url and og:title tags in your themes HTML. -->!-- Read more: http://ogp.me/ -->meta propertyfb:app_id content48119224995 />meta propertyog:site_name contentTumblr />meta propertyog:title contentIPPON Qlikview Blog />meta propertyog:url contenthttps://blog.ipponservices.com/?og1 />meta propertyog:description contentNikolas Daley is a director of Qlikview consultants Ippon Services specialising in Business... />meta propertyog:type contentprofile />meta propertyog:image contenthttps://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj />meta propertyal:ios:url contenttumblr://x-callback-url/blog?blogNameipponservices />meta propertyal:ios:app_name contentTumblr />meta propertyal:ios:app_store_id content305343404 />meta propertyal:android:url contenttumblr://x-callback-url/blog?blogNameipponservices />meta propertyal:android:app_name contentTumblr />meta propertyal:android:package contentcom.tumblr />!-- END TUMBLR FACEBOOK OPENGRAPH TAGS -->!-- TWITTER TAGS -->meta charsetutf-8>meta nametwitter:site contenttumblr />meta nametwitter:card contentsummary />meta nametwitter:description contentNikolas Daley is a director of Qlikview consultants Ippon Services specialising in Business... />meta nametwitter:title contentIPPON Qlikview Blog />meta nametwitter:creator contentIpponservices />meta nametwitter:app:name:iphone contentTumblr />meta nametwitter:app:name:ipad contentTumblr />meta nametwitter:app:name:googleplay contentTumblr />meta nametwitter:app:id:iphone content305343404 />meta nametwitter:app:id:ipad content305343404 />meta nametwitter:app:id:googleplay contentcom.tumblr />meta nametwitter:app:url:iphone contenttumblr://x-callback-url/blog?blogNameipponservices&referrertwitter-cards />meta nametwitter:app:url:ipad contenttumblr://x-callback-url/blog?blogNameipponservices&referrertwitter-cards />meta nametwitter:app:url:googleplay contenttumblr://x-callback-url/blog?blogNameipponservices&referrertwitter-cards />!-- GOOGLE CAROUSEL -->script typeapplication/ld+json>	{@type:ItemList,url:https:\/\/blog.ipponservices.com,itemListElement:{@type:ListItem,position:1,url:https:\/\/blog.ipponservices.com\/post\/141487474087\/qlikview-hitting-targets},{@type:ListItem,position:2,url:https:\/\/blog.ipponservices.com\/post\/141205628262\/qlikview-parsing-html-using-mapsubstring},{@type:ListItem,position:3,url:https:\/\/blog.ipponservices.com\/post\/141030739777\/part-1-the-venice-beach-of-qlikview},{@type:ListItem,position:4,url:https:\/\/blog.ipponservices.com\/post\/140846777617\/qlikview-mind-the-gap},{@type:ListItem,position:5,url:https:\/\/blog.ipponservices.com\/post\/140442019942\/qlikview-lets-get-physical},{@type:ListItem,position:6,url:https:\/\/blog.ipponservices.com\/post\/140340364062\/building-strong-foundations-for-qlikview},{@type:ListItem,position:7,url:https:\/\/blog.ipponservices.com\/post\/140208904542\/avoiding-qlikview-quicksand},{@type:ListItem,position:8,url:https:\/\/blog.ipponservices.com\/post\/31517426401\/using-qlikview-with-openstreetmap},{@type:ListItem,position:9,url:https:\/\/blog.ipponservices.com\/post\/29897899043\/nikolasdaleyvizify},{@type:ListItem,position:10,url:https:\/\/blog.ipponservices.com\/post\/29889290667\/5-qlikview-dashboard-design-tips},@context:http:\/\/schema.org}/script>link relcanonical hrefhttps://blog.ipponservices.com />/head>    body data-urlencoded-nameipponservices classregular index-page display-related-posts>        !-- This is in case the search engine skips the title tag-->        h1 styledisplay: none;>IPPON Qlikview Blog/h1>        div classapp-nag>            div classapp-nag-header clearfix>                div classapp-nag-icon>                    div classapp-nag-icon-ios>                        svg version1.1 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink x0px y0px                             viewBox0 0 1024 1024 enable-backgroundnew 0 0 1024 1024 xml:spacepreserve>                            path fill#36465D dM1024,771c0,139.2-113.8,253-253,253H253C113.8,1024,0,910.2,0,771V253C0,113.8,113.8,0,253,0h518 c139.2,0,253,113.8,253,253V771z/>                            path fillnone stroke#FFF100 stroke-width4 stroke-miterlimit10 dM463.9,209.4/>                            path opacity0.6 fill#231F20 dM628.1,681c8.2,0,17.1-1.2,25.8-3.3V530.3h111.6V401.8h-68.6V473H585.4v162.4 C586,676.3,609.1,681,628.1,681z M654.4,250.5h-68.6v94h68.6V250.5z M754.3,722.9c-12.7,7.1-28.9,12.4-44.3,14.5l11.4,33.8 c-20.5,27-71.4,45.5-118.1,46.3c-1.6,0-3.1,0-4.7,0c0,0,0,0,0,0c-32.5,0-59.5-5.7-81.9-15.3c26.2,40,72.7,72.6,150.5,72.6c0,0,0,0,0,0c1.6,0,3.1,0,4.7,0c46.6-0.8,97.6-19.4,118.1-46.3L754.3,722.9z/>                            path fillnone stroke#FFF100 stroke-width4 stroke-miterlimit10 dM355,359.5/>                            path fill#FFFFFF dM577.5,830.6c65.1,0,129.7-23.2,151-51.3l4.3-5.6l-40.4-119.7c-0.4-1.1-1.4-1.9-2.6-1.9h-7.6h-3.5l-79.1,0 c-1.2,0-2.3-0.8-2.6-2c-1.1-4-1.7-8.9-1.8-14.9V489c0-1.5,1.2-2.7,2.7-2.7h106.1c1.5,0,2.7-1.2,2.7-2.7V333.8c0-1.5-1.2-2.7-2.7-2.7 H598.4c-1.5,0-2.7-1.2-2.7-2.7V182.5c0-1.5-1.2-2.7-2.7-2.7h-82.6h-28.9h-73.8c-13.3,0-28.5,9.8-30.8,28 c-9.3,75.3-43.8,120.5-108.7,142.2l-7.2,2.4c-1.1,0.4-1.9,1.4-1.9,2.6v128.6c0,1.5,1.2,2.7,2.7,2.7h50.4h0h15.9c0,0,0,120,0,158.3 C328.1,771,415.7,830.6,577.5,830.6z M701.6,769.5c-20.3,19.5-62,34.1-102,34.7c-1.5,0-3,0-4.5,0h0 c-131.5,0-166.6-100.4-166.6-159.7V462.3c0-1.5-1.2-2.7-2.7-2.7h-63.6c-1.5,0-2.7-1.2-2.7-2.7v-83c0-1.1,0.7-2.1,1.7-2.5 c68-26.5,105.9-79,115.9-160.3c0.6-4.5,4.3-4.6,4.3-4.6h84.9c1.5,0,2.7,1.2,2.7,2.7v145.9c0,1.5,1.2,2.7,2.7,2.7h105.7 c1.5,0,2.7,1.2,2.7,2.7v96.4c0,1.5-1.2,2.7-2.7,2.7H571.3c-1.5,0-2.7,1.2-2.7,2.7l0,173.2c0.6,39,19.5,58.8,56.1,58.8 c14.7,0,31.6-3.4,47.1-9.3c1.4-0.6,3,0.2,3.5,1.6l27,80C702.6,767.7,702.4,768.8,701.6,769.5z/>                            path opacity0.5 fill#2D3F54 dM328.1,528.9h73.8v-40.2c0-1.3-1.1-2.4-2.4-2.4h-71.4V528.9z/>                        /svg>                    /div>                    div classapp-nag-icon-android>                        svg version1.1 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink x0px y0px viewBox0 0 1024 1024 enable-backgroundnew 0 0 1024 1024 xml:spacepreserve>                            path fillnone stroke#FFF100 stroke-width4 stroke-miterlimit10 dM463.9,209.4>/path>                            path opacity0.5 fill#231F20 dM628.1,681c8.2,0,17.1-1.2,25.8-3.3V530.3h111.6V401.8h-68.6V473H585.4v162.4 C586,676.3,609.1,681,628.1,681z M654.4,250.5h-68.6v94h68.6V250.5z M754.3,722.9c-12.7,7.1-28.9,12.4-44.3,14.5l11.4,33.8 c-20.5,27-71.4,45.5-118.1,46.3c-1.6,0-3.1,0-4.7,0c0,0,0,0,0,0c-32.5,0-59.5-5.7-81.9-15.3c26.2,40,72.7,72.6,150.5,72.6c0,0,0,0,0,0c1.6,0,3.1,0,4.7,0c46.6-0.8,97.6-19.4,118.1-46.3L754.3,722.9z>/path>                            path fillnone stroke#FFF100 stroke-width4 stroke-miterlimit10 dM355,359.5>/path>                            path fill#36465D dM577.5,830.6c65.1,0,129.7-23.2,151-51.3l4.3-5.6l-40.4-119.7c-0.4-1.1-1.4-1.9-2.6-1.9h-7.6h-3.5l-79.1,0 c-1.2,0-2.3-0.8-2.6-2c-1.1-4-1.7-8.9-1.8-14.9V489c0-1.5,1.2-2.7,2.7-2.7h106.1c1.5,0,2.7-1.2,2.7-2.7V333.8c0-1.5-1.2-2.7-2.7-2.7 H598.4c-1.5,0-2.7-1.2-2.7-2.7V182.5c0-1.5-1.2-2.7-2.7-2.7h-82.6h-28.9h-73.8c-13.3,0-28.5,9.8-30.8,28 c-9.3,75.3-43.8,120.5-108.7,142.2l-7.2,2.4c-1.1,0.4-1.9,1.4-1.9,2.6v128.6c0,1.5,1.2,2.7,2.7,2.7h50.4h0h15.9c0,0,0,120,0,158.3 C328.1,771,415.7,830.6,577.5,830.6z M701.6,769.5c-20.3,19.5-62,34.1-102,34.7c-1.5,0-3,0-4.5,0h0 c-131.5,0-166.6-100.4-166.6-159.7V462.3c0-1.5-1.2-2.7-2.7-2.7h-63.6c-1.5,0-2.7-1.2-2.7-2.7v-83c0-1.1,0.7-2.1,1.7-2.5 c68-26.5,105.9-79,115.9-160.3c0.6-4.5,4.3-4.6,4.3-4.6h84.9c1.5,0,2.7,1.2,2.7,2.7v145.9c0,1.5,1.2,2.7,2.7,2.7h105.7 c1.5,0,2.7,1.2,2.7,2.7v96.4c0,1.5-1.2,2.7-2.7,2.7H571.3c-1.5,0-2.7,1.2-2.7,2.7l0,173.2c0.6,39,19.5,58.8,56.1,58.8 c14.7,0,31.6-3.4,47.1-9.3c1.4-0.6,3,0.2,3.5,1.6l27,80C702.6,767.7,702.4,768.8,701.6,769.5z>/path>                            path opacity0.5 fill#2D3F54 dM328.1,528.9h73.8v-40.2c0-1.3-1.1-2.4-2.4-2.4h-71.4V528.9z>/path>                        /svg>                    /div>                /div>                div classapp-nag-ratings>                    svg width181px height30px viewBox0 0 181 30 version1.1 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink>                        g strokenone stroke-width1 fillnone fill-ruleevenodd>                            path dM15.8,25.2 L6.1,29.8 L7.5,19.2 L0.1,11.4 L10.6,9.5 L15.8,0 L20.9,9.5 L31.4,11.4 L24,19.2 L25.4,29.8 L15.8,25.2 Z fill#FFC00E>/path>                            path dM52.8,25.2 L43.1,29.8 L44.5,19.2 L37.1,11.4 L47.6,9.5 L52.8,0 L57.9,9.5 L68.4,11.4 L61,19.2 L62.4,29.8 L52.8,25.2 Z fill#FFC00E>/path>                            path dM89.8,25.2 L80.1,29.8 L81.5,19.2 L74.1,11.4 L84.6,9.5 L89.8,0 L94.9,9.5 L105.4,11.4 L98,19.2 L99.4,29.8 L89.8,25.2 Z fill#FFC00E>/path>                            path dM126.8,25.2 L117.1,29.8 L118.5,19.2 L111.1,11.4 L121.6,9.5 L126.8,0 L131.9,9.5 L142.4,11.4 L135,19.2 L136.4,29.8 L126.8,25.2 Z fill#FFC00E>/path>                            path dM163.8,25.2 L154.1,29.8 L155.5,19.2 L148.1,11.4 L158.6,9.5 L163.8,0 L168.9,9.5 L179.4,11.4 L172,19.2 L173.4,29.8 L163.8,25.2 Z fill#E7E7E7>/path>                            path dM163.3,25.1 L154.1,29.8 L155.5,19.2 L148.1,11.4 L158.6,9.5 L163.3,0.9 L163.3,25.1 Z fill#FFC00E>/path>                        /g>                    /svg>                    div classapp-nag-ratings-text app-nag-ratings-text-android>                        1.5M ratings                    /div>                    div classapp-nag-ratings-text app-nag-ratings-text-ios>                        277k ratings                    /div>                /div>                div classapp-nag-close-button>                    svg width15px height15px viewBox0 0 30 30 version1.1 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink>                        g strokenone stroke-width1 fillnone fill-ruleevenodd>                            path dM12.510351,14.6860639 L0,27.1964147 L2.175713,29.3721278 L14.686064,16.8617771 L27.196415,29.3721278 L29.372128,27.1964147 L16.861777,14.6860639 L29.372128,2.1757132 L27.196415,0 L14.686064,12.5103507 L2.175713,0 L0,2.1757132 L12.510351,14.6860639 L12.510351,14.6860639 Z fill#D3D3D3>/path>                        /g>                    /svg>                /div>            /div>            div classapp-nag-body>                h2 classapp-nag-callout>See, that’s what the app is perfect for./h2>                a classapp-nag-large-button app-nag-app-store-link button blue>Sounds perfect/a>                a classapp-nag-large-button app-nag-app-store-deny>Wahhhh, I don’t wanna/a>            /div>        /div>        section idpage classh-feed>            div classheader-wrapper                                                                avatar-style-circle>                header idheader classtop-blog-header>                                        div classheader-image-wrapper >                        a href/ classheader-image parallax cover  data-bg-imagehttps://static.tumblr.com/3b975cedd10907468133305a34b37162/zcdpezf/UCZo3icm0/tumblr_static_6kbnzikxf64ocsc0480gcog8s_2048_v2.png>                                                    /a>                        div classloader-bg>/div>                    /div>                                        div classblog-title-wrapper content>                        figure classavatar-wrapper animate  p-author h-card>                            a href/ stylebackground-image: url(https://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj) classuser-avatar >img srchttps://64.media.tumblr.com/avatar_f141d3edbc15_128.pnj altipponservices classprint-only invisible>/a>                        /figure>                        div classtitle-group animate>                                                        h1 classblog-title p-name>a href/>IPPON Qlikview Blog/a>/h1>                                                                                    span classdescription p-summary>                                Nikolas Daley is a director of Qlikview consultants Ippon Services specialising in Business Intelligence software development for the finance industry. The software we develop aims to deliver business discovery and actionable reporting, presenting and analysing data in such a way that users are empowered to make informed business decisions.                            /span>                                                                                /div>                    /div>                /header>            /div>                            div classnav-wrapper nav-responsive>                    nav classnav-menu>                        ul classinline-nav>                            li classnav-item nav-item--posts>                                a href/ classlabel current-page>Posts/a>                            /li>                                                            li classnav-item nav-item--likes>                                    a href/likes classlabel >Likes/a>                                /li>                                                                                                                                                                                                            li classnav-item nav-item--page>                                    a href/home classlabel  external-page>Ippon Services Ltd/a>                                /li>                                                                                        li classnav-item nav-item--archive>                                a href/archive classlabel external-page>Archive/a>                            /li>                        /ul>                    /nav>                /div>                                                                                                    section idposts classcontent clearfix  avatar-style-circle  show-nav>                                div classcontainer>                    div classmain>                                                        article classtext not-page post-141487474087  data-post-id141487474087 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/141487474087/qlikview-hitting-targets classu-url>Qlikview - Hitting Targets/a>/h2>                                                                                                    div classbody-text e-content>p>Steve Dark recently posted a hrefhttp://www.quickintelligence.co.uk/qlik-target-bar-chart/>an excellent article/a> on his Quick Intelligence blog (a hrefhttps://community.qlik.com/docs/DOC-16258>and example code/a>) detailing a simple technique to create a chart to show Variance to Target. The result is a chart like this :/p>figure data-orig-width547 data-orig-height216 classtmblr-full>img srchttps://64.media.tumblr.com/cc78ee2ace0924856d85950381872c9b/tumblr_inline_o4fzk8Yy9i1r8fkpz_640.png altimage data-orig-width547 data-orig-height216 width547 height216 />/figure>p>What we have is a stacked bar chart, the Grey bar represents the Target value, where the actual value is Under Target it is represented by a Red bar and finally where we are Over Target we render in Green (yes I know not very colour blind friendly).br />/p>p>My problem with this solution is quite literally “the grey area”. Take “Fri 18 March” as an example, did we match the Target on this day or did we not have any values at all ? To make this clearer I elaborated on the chart to add “weight” to the Target values. This is a technique where context is added to the measure by tweaking the Alpha value of the rendered colour./p>figure data-orig-width547 data-orig-height211 classtmblr-full>img srchttps://64.media.tumblr.com/e6eaef6fb33abaf6cc8c5c29c872e934/tumblr_inline_o4fzn0IJyR1r8fkpz_640.png altimage data-orig-width547 data-orig-height211 width547 height211 />/figure>p>The result above is achieved in Qlikview by adjusting the Background Colour value of the Target expression. Now the measures that have matched the Target are rendered in the solid Grey and the missed Target values are given a lighter weight./p>p>I pushed the chart a little further to add some additional contextual information around variance. I wanted to show for each day how we performed +/- against Target. To do this I added two new Symbol expressions to the chart, the Triangle (Up) to represent positive variance and Triangle (Down) to represent negative. The value of these expression was initially set as either the larger of Target or Over Target measures. As can be see below this presented a problem…/p>figure data-orig-width536 data-orig-height211 classtmblr-full>img srchttps://64.media.tumblr.com/aa541245056e7a78a98d8f7518009ac5/tumblr_inline_o4g0c1Q0x61r8fkpz_540.png altimage data-orig-width536 data-orig-height211 width536 height211 />/figure>p>…. not quite the effect I was looking for. What I wanted was to slightly offset the symbol from the end of the bar so I simply added a small proportional amount onto the expression value to get the layout I wanted ……/p>figure data-orig-width541 data-orig-height213 classtmblr-full>img srchttps://64.media.tumblr.com/1e8954848b8f4f0dfb3d256def3093de/tumblr_inline_o4g0jaBLyN1r8fkpz_640.png altimage data-orig-width541 data-orig-height213 width541 height213 />/figure>p>I also wanted to show an actual variance figure alongside the symbol. This is possible by creating the expression value as a Dual() and selecting the “Value On Data Points” property. The first value in the Dual() will be used for the display value, the second for the actual value plotted. This enabled me to maintain the offset (by upping the plotted value) while displaying the variance from target./p>figure data-orig-width542 data-orig-height211 classtmblr-full>img srchttps://64.media.tumblr.com/f24603eb8e5c3e92fc238d44c87f4269/tumblr_inline_o4g0rluT0x1r8fkpz_640.png altimage data-orig-width542 data-orig-height211 width542 height211 />/figure>p>An added bonus of including this variance figure is that it helped to add extra context to the days where target had been matched by plotting a +0/p>p>Hopefully this can be of use to you in your own applications./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/business%20intelligence>business intelligence/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qliksense>qliksense/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlik>qlik/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/bar%20chart>bar chart/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/141487474087/qlikview-hitting-targets title8 years ago classmeta-item post-date>Mar 22nd, 2016/a>time classdt-published datetime2016-03-22 13:54:00>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_141487474087>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post141487474087>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141487474087%2Fqlikview-hitting-targets&tQlikview%20-%20Hitting%20Targets classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textQlikview%20-%20Hitting%20Targets%20-%20Steve%20Dark%20recently%20posted%20an%20excellent%20article%20on%20his%20Quick%20Intelligence%20blog%20%28and%20example%20code%29%20detailing%20a%20simple%20technique%20to%20create%20a%20chart%20to%20show%20Variance%20to%20Target.%20The%20result%20is%20a%20chart%20like%20this%20%3A%20What%20we...%20https%3A%2F%2Ftmblr.co%2FZUt7nv23nJuMd classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141487474087%2Fqlikview-hitting-targets classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyQlikview%20-%20Hitting%20Targets%20-%20Steve%20Dark%20recently%20posted%20an%20excellent%20article%20on%20his%20Quick%20Intelligence%20blog%20%28and%20example%20code%29%20detailing%20a%20simple%20technique%20to%20create%20a%20chart%20to...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141487474087%2Fqlikview-hitting-targets classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/141487474087/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/141487474087/qlikview-hitting-targets classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/141487474087/eV58WStW classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id141487474087 data-blog-nameipponservices idlike_button_141487474087>iframe idlike_iframe_141487474087 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id141487474087&colorblack&rkeV58WStW&slugqlikview-hitting-targets scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_141487474087>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-141205628262  data-post-id141205628262 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/141205628262/qlikview-parsing-html-using-mapsubstring classu-url>Qlikview - Parsing HTML using MapSubString()/a>/h2>                                                                                                    div classbody-text e-content>p>Sometimes you come across a function in Qlikview, that you haven’t previously used, that so perfectly solves your current problem it seems like it has been created just for you. /p>p>The problem was an attempt to load data from a field that contained text in a HTML format. As there is no inbuilt HTML parser in QV I needed a quick way to strip out the tags from the field to leave me with just plain text.  I found a inspiration for the solution as always on the a hrefhttps://community.qlik.com/thread/71215>Qlik Community Forum/a>./p>p>The solution was to use Qlikview’s a hrefhttp://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/MapSubstring.htm?qmapsubstring>MapSubstring()/a> function. Very similar in basic function to a standard a hrefhttp://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/ApplyMap.htm?qapplymap>ApplyMap()/a> call it differs in that it will parse through an expression left-to-right and replace any of the values it finds in the Mapping Table, rather than trying to match the expression in its entirety. /p>p>For Example :/p>p>We have a table containing Products with a field containing Product Color Codes/p>figure data-orig-height80 data-orig-width193 data-orig-srchttps://64.media.tumblr.com/a5b2d1974fd48d2b1f606278e72de66b/tumblr_inline_o46fmngaye1r8fkpz_540.png>img srchttps://64.media.tumblr.com/fcfb5ba925ff6441a453b478eb325bbe/tumblr_inline_pjzy4dA9jj1r8fkpz_250.png altimage data-orig-height80 data-orig-width193 data-orig-srchttps://64.media.tumblr.com/a5b2d1974fd48d2b1f606278e72de66b/tumblr_inline_o46fmngaye1r8fkpz_540.png width193 height80 />/figure>p>We define a Mapping table as usual for each of the ProductColorCodes values/p>figure data-orig-height120 data-orig-width286 data-orig-srchttps://64.media.tumblr.com/e769f62a4583fa8d773ef5c767fe7208/tumblr_inline_o46fy2iIXT1r8fkpz_540.png>img srchttps://64.media.tumblr.com/4d88398aa2c8c50bf5f72f40dbebef64/tumblr_inline_pjzy4erI3k1r8fkpz_400.png altimage data-orig-height120 data-orig-width286 data-orig-srchttps://64.media.tumblr.com/e769f62a4583fa8d773ef5c767fe7208/tumblr_inline_o46fy2iIXT1r8fkpz_540.png width286 height120 />/figure>p>We can then use the MapSubString() function to replace the ProductColorCodes values with the ProductColor values./p>p>b>MapSubString(‘ProductColorCodes_Map’,ProductColorCodes) as ProductColors/b>/p>figure data-orig-height80 data-orig-width296 data-orig-srchttps://64.media.tumblr.com/dadc25f105bc1cf7da3e2944fc3eafc1/tumblr_inline_o46g6sVHkS1r8fkpz_540.png>img srchttps://64.media.tumblr.com/cebd1bac84d3856a4e678780c896481b/tumblr_inline_pjzy4eIHK71r8fkpz_400.png altimage data-orig-height80 data-orig-width296 data-orig-srchttps://64.media.tumblr.com/dadc25f105bc1cf7da3e2944fc3eafc1/tumblr_inline_o46g6sVHkS1r8fkpz_540.png width296 height80 />/figure>p>Back to the problem at hand and my field of HTML tagged data. The first thing to do was extract all the <i>Tags/i>> into a mapping table and define a substitute for them. /p>p>Take this chunk of text as an example from field b>htmlfield /b>…./p>figure classtmblr-full data-orig-height139 data-orig-width481 data-orig-srchttps://64.media.tumblr.com/c00fe570291d45007935bbb8621fda04/tumblr_inline_o46hfgyRO21r8fkpz_540.png>img srchttps://64.media.tumblr.com/dd8f1f4026179802011e61e10d60b0c9/tumblr_inline_pjzy4e1XrA1r8fkpz_500.png alt data-orig-height139 data-orig-width481 data-orig-srchttps://64.media.tumblr.com/c00fe570291d45007935bbb8621fda04/tumblr_inline_o46hfgyRO21r8fkpz_540.png width481 height139 />/figure>p>… and parse it using the following code/p>p>b>’<’ & TextBetween(SubField(htmlfield, ’<’),“,’>’) & ’>’ as HtmlTag/b>/p>p>Lets chunk that code down and see whats going on/p>p>First we have a a hrefhttp://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm?qsubfield>b>SubField()/b>/a> call. This is taking the b>htmlfield/b> value and splitting it based on the supplied delimiter b>‘<’/b>. Our resulting data looks like this :/p>figure classtmblr-full data-orig-height270 data-orig-width420 data-orig-srchttps://64.media.tumblr.com/e61f7b6d750a9efda681d31456f01e45/tumblr_inline_o46j67wEfW1r8fkpz_540.png>img srchttps://64.media.tumblr.com/8843b0ea0495e796d2fa4cebdd03a82a/tumblr_inline_pjzy4fkS0A1r8fkpz_500.png alt data-orig-height270 data-orig-width420 data-orig-srchttps://64.media.tumblr.com/e61f7b6d750a9efda681d31456f01e45/tumblr_inline_o46j67wEfW1r8fkpz_540.png width420 height270 />/figure>p>We then wrap that resulting data up in a b>a hrefhttp://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/TextBetween.htm?qtextbetween>TextBetween()/a>/b> call to extract all data to the left of b>‘>’ /b>and discard the values that were wrapped in the tags./p>p>b>TextBetween(SubField(htmlfield, ’<’),”,’>’)/b>/p>figure classtmblr-full data-orig-height194 data-orig-width398 data-orig-srchttps://64.media.tumblr.com/71ba7e03416b10ab9fd63f01eecc19b8/tumblr_inline_o46jh24X3K1r8fkpz_540.png>img srchttps://64.media.tumblr.com/cc706da7b1bf73b54ad8208d435d0596/tumblr_inline_pjzy4ff6Tg1r8fkpz_400.png altimage data-orig-height194 data-orig-width398 data-orig-srchttps://64.media.tumblr.com/71ba7e03416b10ab9fd63f01eecc19b8/tumblr_inline_o46jh24X3K1r8fkpz_540.png width398 height194 />/figure>p>Finally wrap this result in ‘<’ ‘>’ to give us our final list of extracted HTML tags/p>p>b>’<’ & TextBetween(SubField(htmlfield, ’<’),“,’>’) & ’>’/b>/p>p>Pulling this all together into a b>MAPPING LOAD/b> table we define a b>Substitute/b> field which we will replace the <i>Tags/i>> with. In this example I’m going to useb> ‘|’/b>/p>p>b>HtmlTag_Map:br />MAPPING LOAD br />DISTINCT br />	’<’ & TextBetween(SubField(htmlfield, ’<’),”,’>’) & ’>’ as HtmlTag,br />	’|’ as Substitutebr />RESIDENT ……br />; /b>/p>p>This gives us our final mapping table which looks like this/p>figure classtmblr-full data-orig-height214 data-orig-width484 data-orig-srchttps://64.media.tumblr.com/e705fa4efc76d3f27beb72775d7e7aac/tumblr_inline_o46kbtdDTh1r8fkpz_540.png>img srchttps://64.media.tumblr.com/632d50d7c0e97e849af08a76761481a0/tumblr_inline_pjzy4fXUlO1r8fkpz_500.png altimage data-orig-height214 data-orig-width484 data-orig-srchttps://64.media.tumblr.com/e705fa4efc76d3f27beb72775d7e7aac/tumblr_inline_o46kbtdDTh1r8fkpz_540.png width484 height214 />/figure>p>We can then use our MapSubString() function on the original b>htmlfield/b> value to replace all the <i>Tags/i>> with |/p>p>b>MapSubstring(HtmlTag_Map’, htmlfield) as HtmlFieldParsed /b>/p>p>This leaves us with the following text string. /p>figure data-orig-width776 data-orig-height40 classtmblr-full>img srchttps://64.media.tumblr.com/4fbc7fbb0836d8cea35254b5028f7992/tumblr_inline_o46lr8T8RD1r8fkpz_1280.png altimage data-orig-width776 data-orig-height40 width700 height36 />/figure>p>As you can see where <i>Tags/i>> were nested we have instances with multiple vertical bars. Once again MapSubString() comes to our rescue. As we do not know how many nested tags may be in our text field we will throw caution to the wind and knock up a quick MAPPING LOAD using AUTOGENERATE for 1 to a 100 bars to be replace with a space :br />/p>p>b>VerticleBar_Map:br />MAPPING LOAD br />	 Repeat(’|’,IterNo()) as Bars,br />	 ’ ’ as Substitutebr />AUTOGENERATE 1 WHILE IterNo() < 100;/b>/p>p>We can then use this additional MAPPING LOAD to wrap our HTML stripping code/p>p>b>MapSubString(VerticleBar_Map’,MapSubstring(HtmlTag_Map’, htmlfield)) as HtmlFieldParsed /b>/p>p>…giving us our final resulting field /p>figure data-orig-width773 data-orig-height42 classtmblr-full>img srchttps://64.media.tumblr.com/bd51a6752f9e5a88ca43b751b6c1d29e/tumblr_inline_o46lyjmWMz1r8fkpz_1280.png altimage data-orig-width773 data-orig-height42 width700 height38 />/figure>p>I hope you have enjoyed this example of MapSubString(), as you can see its a great alternative to nested Replace() or PurgeChar() functions./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlik%20sense>qlik sense/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/business%20intelligence>business intelligence/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/141205628262/qlikview-parsing-html-using-mapsubstring title8 years ago classmeta-item post-date>Mar 17th, 2016/a>time classdt-published datetime2016-03-17 16:09:38>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_141205628262>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post141205628262>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141205628262%2Fqlikview-parsing-html-using-mapsubstring&tQlikview%20-%20Parsing%20HTML%20using%20MapSubString%28%29 classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textQlikview%20-%20Parsing%20HTML%20using%20MapSubString%28%29%20-%20Sometimes%20you%20come%20across%20a%20function%20in%20Qlikview%2C%20that%20you%20haven%E2%80%99t%20previously%20used%2C%20that%20so%20perfectly%20solves%20your%20current%20problem%20it%20seems%20like%20it%20has%20been%20created%20just%20for%20you.%C2%A0%20The%20problem%20was%20an...%20https%3A%2F%2Ftmblr.co%2FZUt7nv23WWkLc classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141205628262%2Fqlikview-parsing-html-using-mapsubstring classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyQlikview%20-%20Parsing%20HTML%20using%20MapSubString%28%29%20-%20Sometimes%20you%20come%20across%20a%20function%20in%20Qlikview%2C%20that%20you%20haven%E2%80%99t%20previously%20used%2C%20that%20so%20perfectly%20solves%20your...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141205628262%2Fqlikview-parsing-html-using-mapsubstring classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/141205628262/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/141205628262/qlikview-parsing-html-using-mapsubstring classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/141205628262/UZA4NcJx classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id141205628262 data-blog-nameipponservices idlike_button_141205628262>iframe idlike_iframe_141205628262 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id141205628262&colorblack&rkUZA4NcJx&slugqlikview-parsing-html-using-mapsubstring scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_141205628262>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classlink not-page post-141030739777  data-post-id141030739777 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                                                                                                                                                                                                        div classpost-content h-entry with-caption with-thumbnail>                                                div classlink-wrapper>                                                    a  hrefhttps://qlikies.wordpress.com/2016/03/01/part-1-the-venice-beach-of-qlikview/ classlink u-bookmark-of h-cite>                                                                                                                div classlink-thumbnail>img classu-photo srchttps://64.media.tumblr.com/e14325c24aecd0bedd465f314111cdce/tumblr_o4186n8BRT1rrppcd_og_1280.jpg alt />/div>                                                                                                                div classlink-text-wrapper clearfix>                                                            div classlink-text>                                                                                                                                div classlink-host>qlikies.wordpress.com/div>                                                                                                                                h2 classlink-title p-name>Part 1 – The Venice Beach of QlikView/h2>                                                                                                                                div classlink-excerpt p-summary>Venice Beach, the mecca of pec popping and quad flexing in the US of A. So what does Venice Beach and QlikView have in common. Well, actually quite a bit and just like Arnold Schwarzenegger went on…/div>                                                                                                                                                                                            /div>                                                        /div>                                                    /a>                                                /div>                                                                                                    div classcaption e-summary>                                                        p>An excellent article by a hrefhttps://qlikies.wordpress.com/>Byron Van Wyk/a> on building Self Service charts using dollar expansion to create dynamic Dimensions and Measures./p>                                                    /div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/141030739777/part-1-the-venice-beach-of-qlikview title8 years ago classmeta-item post-date>Mar 14th, 2016/a>time classdt-published datetime2016-03-14 13:59:11>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_141030739777>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post141030739777>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141030739777%2Fpart-1-the-venice-beach-of-qlikview&tIPPON%20Qlikview%20Blog classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textPart%201%20%E2%80%93%20The%20Venice%20Beach%20of%20QlikView%20-%20An%20excellent%20article%20by%20Byron%20Van%20Wyk%20on%20building%20Self%20Service%20charts%20using%20dollar%20expansion%20to%20create%20dynamic%20Dimensions%20and%20Measures.%20https%3A%2F%2Ftmblr.co%2FZUt7nv23M5az1 classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141030739777%2Fpart-1-the-venice-beach-of-qlikview classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20link%20from%20IPPON%20Qlikview%20Blog&bodyPart%201%20%E2%80%93%20The%20Venice%20Beach%20of%20QlikView%20-%20An%20excellent%20article%20by%20Byron%20Van%20Wyk%20on%20building%20Self%20Service%20charts%20using%20dollar%20expansion%20to%20create%20dynamic%20Dimensions%20and...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F141030739777%2Fpart-1-the-venice-beach-of-qlikview classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/141030739777/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/141030739777/part-1-the-venice-beach-of-qlikview classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/141030739777/3gQzDgp5 classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id141030739777 data-blog-nameipponservices idlike_button_141030739777>iframe idlike_iframe_141030739777 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id141030739777&colorblack&rk3gQzDgp5&slugpart-1-the-venice-beach-of-qlikview scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_141030739777>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-140846777617  data-post-id140846777617 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/140846777617/qlikview-mind-the-gap classu-url>Qlikview - Mind the gap/a>/h2>                                                                                                    div classbody-text e-content>p>At some point working with data visualisations you will encounter the problem of how to represent missing data. How we deal with this is determined by the context of the data itself.br />/p>p>As an example consider the following data. Note that we do not have Sales available for 2014  :/p>figure data-orig-width129 data-orig-height139>img srchttps://64.media.tumblr.com/02478e3e062a1cd1a3a77ccc20676613/tumblr_inline_o3q2g4fkXH1r8fkpz_250.png altimage data-orig-width129 data-orig-height139 width129 height139 />/figure>p>When this data is plotted into a simple Line Chart it presents us immediately with a problem. /p>figure data-orig-width529 data-orig-height320 classtmblr-full>img srchttps://64.media.tumblr.com/699eb2f384cd32c30887dff35367f420/tumblr_inline_o3q2m9ELuL1r8fkpz_540.png altimage data-orig-width529 data-orig-height320 width529 height320 />/figure>p>As you can see there is no data for the Year 2014 yet by default the Line Chart connects the points for 2013 and 2015 appearing to show an upward trend. This is of course misleading as we do not know what happened in 2014. br />/p>p>To better represent the data we need to ensure that we have an entry for 2014. We cannot simply backfill a zero into 2014 as in the context of this data there is a big difference between zero sales and not knowing how many sales were made. Therefore we would look to ensure we have a Null entry added for Sales in 2014. However the line chart will still plot this Null value as a zero so we must make sure the visualisation distinguishes this entry from an actual zero. Below you can see I have used a dashed line to connect the missing data on the line chart and I have also included a bar chart in the background to emphasise that the data is missing. /p>figure data-orig-width530 data-orig-height320 classtmblr-full>img srchttps://64.media.tumblr.com/0c4dfb62b2652e0adaca4d6d29df4d7d/tumblr_inline_o3q2trat3G1r8fkpz_540.png altimage data-orig-width530 data-orig-height320 width530 height320 />/figure>p>The effect is achieved by changing the Background Color and Line Style values for the Sales expression if it evaluates to Null. To ensure that both connecting lines to the datapoint are formatted we also check the preceding value with the Above() function./p>p>//Background Colorbr />if(isnull(max({<IsCurrentYear{1}>}Sales)) or isnull(above(max({<IsCurrentYear{1}>}Sales),-1)),green(75),green()) br />br />//Line Stylebr />if(isnull(max({<IsCurrentYear{1}>}Sales)) or isnull(above(max({<IsCurrentYear{1}>}Sales),-1)),’<S3>’,’<S1>’)  /p>p>They may however be contexts which allow us to make a very different approach to missing data. Take for instance this a hrefhttps://docs.google.com/spreadsheets/d/1IbDM8z5XicMIXgr93FPwjgwoTTKMuyLfzU6cQrGZzH8/pub?gid0>Population data/a> for China taken from a hrefhttp://www.gapminder.org/>Gapminder/a>. From 1800 to 1950 we only have a Population value available every decade. However we can still plot this data into a line chart and observer the upwards trend over time. In the context of this data we are happy to allow for the chart to use linear interpolation for the missing years./p>figure data-orig-width545 data-orig-height329 classtmblr-full>img srchttps://64.media.tumblr.com/4fef1c258e7214113eabb9a075ddd21e/tumblr_inline_o3q5oxXcrM1r8fkpz_640.png altimage data-orig-width545 data-orig-height329 width545 height329 />/figure>p>We start to run into problems though when we want to represent the Population at a specific point of time for which we do not have data. For example in this Animated Bubble chart we are comparing the Income Per Person to Life Expectancy over time. We are setting the size of the bubble based on the Population size and as can be seen in this video, for years where we have no data, the bubble disappears./p>figure classtmblr-embed tmblr-full>iframe idembed-67386af1b248f168778980 classembed_iframe srchttps://safe.txmblr.com/svc/embed/inline/https%3A%2F%2Fyoutu.be%2Fc9JZ6vpzi4c#embed-67386af1b248f168778980-partied width700 height524 scrollingno frameborder0 allowfullscreenallowfullscreen mozallowfullscreen webkitallowfullscreen>/iframe>/figure>p>To fix this problem we can persist the Population data into missing years using the Qlikview Peek function during the scripted data load. This line of code effectively propagates available data from the previously populated record into any NULL records./p>figure data-orig-width555 data-orig-height16 classtmblr-full>img srchttps://64.media.tumblr.com/bd96b065ec520d18bb3023f4368f107a/tumblr_inline_o3s1b8AZQE1r8fkpz_640.png altimage data-orig-width555 data-orig-height16 width555 height16 />/figure>p>Once the missing data is back filled the Animation will render correctly, showing a static bubble size for the estimated years. I have elaborated on this further to change the alpha value for the estimated years to distinguish them from the verified data (This would of course have to be explained in the charts legend)/p>figure classtmblr-embed tmblr-full>iframe idembed-67386af1b2551178867652 classembed_iframe srchttps://safe.txmblr.com/svc/embed/inline/https%3A%2F%2Fyoutu.be%2Fk4UF8BK8eNY#embed-67386af1b2551178867652-partied width700 height524 scrollingno frameborder0 allowfullscreenallowfullscreen mozallowfullscreen webkitallowfullscreen>/iframe>/figure>p>In summary missing data can be handled and represented in very different ways. An important consideration of the approach to take is the context of the data, how can we give meaning to the missing values in the visualisation we choose./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/business%20intelligence>business intelligence/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/140846777617/qlikview-mind-the-gap title8 years ago classmeta-item post-date>Mar 11th, 2016/a>time classdt-published datetime2016-03-11 08:35:51>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_140846777617>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post140846777617>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140846777617%2Fqlikview-mind-the-gap&tQlikview%20-%20Mind%20the%20gap classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textQlikview%20-%20Mind%20the%20gap%20-%20At%20some%20point%20working%20with%20data%20visualisations%20you%20will%20encounter%20the%20problem%20of%20how%20to%20represent%20missing%20data.%20How%20we%20deal%20with%20this%20is%20determined%20by%20the%20context%20of%20the%20data%20itself.%20As%20an%20example%20consider%20the%20following...%20https%3A%2F%2Ftmblr.co%2FZUt7nv23B7qKH classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140846777617%2Fqlikview-mind-the-gap classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyQlikview%20-%20Mind%20the%20gap%20-%20At%20some%20point%20working%20with%20data%20visualisations%20you%20will%20encounter%20the%20problem%20of%20how%20to%20represent%20missing%20data.%20How%20we%20deal%20with%20this%20is%20determined%20by%20the...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140846777617%2Fqlikview-mind-the-gap classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/140846777617/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/140846777617/qlikview-mind-the-gap classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/140846777617/K9C9QwP0 classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id140846777617 data-blog-nameipponservices idlike_button_140846777617>iframe idlike_iframe_140846777617 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id140846777617&colorblack&rkK9C9QwP0&slugqlikview-mind-the-gap scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_140846777617>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-140442019942  data-post-id140442019942 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/140442019942/qlikview-lets-get-physical classu-url>Qlikview - Lets get physical/a>/h2>                                                                                                    div classbody-text e-content>p>In my a hrefhttp://blog.ipponservices.com/post/140340364062/building-strong-foundations-for-qlikview>previous post/a> I mentioned that the preferred dimensional-model for a data model is the Star Schema. I came across this interesting diagram in a a hrefhttps://community.qlik.com/docs/DOC-4556>Qlikview Best Practices document/a> that demonstrates just why this is the case :/p>figure classtmblr-full data-orig-height532 data-orig-width637>img srchttps://64.media.tumblr.com/5bf5bd9a47a135f26db86d515ff555e3/tumblr_inline_o3iho7KZ4G1r8fkpz_640.png data-orig-height532 data-orig-width637 width637 height532 altimage />/figure>p>As you can see across the areas of performance, complexity and flexibility the Star Schema is generally the best choice./p>p>So lets take the logical Star Schema Bubble Chart we defined during Kimball modelling phase and implement this as a Qlikview data-model :/p>figure classtmblr-full data-orig-height246 data-orig-width599>img srchttps://64.media.tumblr.com/2e86ccc3d29b96d7d4f74bbadcdbade9/tumblr_inline_o3ihoiy2du1r8fkpz_640.png data-orig-height246 data-orig-width599 width599 height246 altimage />/figure>p>b>Dimensions/b>/p>p>The Country and Region have been denormalised into a single dimension table. A Surrogate Key %Country has been defined for the Natural Key Country. The same process has been followed for the Years dimension adding in the additional attributes of Decade and Century./p>p>b>Facts/b>/p>p>The Income Per Person and Life Expectancy facts have been captured in a single fact table through the use of concatenation at the defined grain level of per Country per Year. Foreign Keys have been defined linking the facts to the relevant Dimensions./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/kimball>kimball/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/dimensional%20models>dimensional models/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/140442019942/qlikview-lets-get-physical title8 years ago classmeta-item post-date>Mar 4th, 2016/a>time classdt-published datetime2016-03-04 11:58:33>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_140442019942>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post140442019942>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140442019942%2Fqlikview-lets-get-physical&tQlikview%20-%20Lets%20get%20physical classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textQlikview%20-%20Lets%20get%20physical%20-%20In%20my%20previous%20post%20I%20mentioned%20that%20the%20preferred%20dimensional-model%20for%20a%20data%20model%20is%20the%20Star%20Schema.%20I%20came%20across%20this%20interesting%20diagram%20in%20a%20Qlikview%20Best%20Practices%20document%20that%20demonstrates%20just%20why%20this...%20https%3A%2F%2Ftmblr.co%2FZUt7nv22o-oXc classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140442019942%2Fqlikview-lets-get-physical classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyQlikview%20-%20Lets%20get%20physical%20-%20In%20my%20previous%20post%20I%20mentioned%20that%20the%20preferred%20dimensional-model%20for%20a%20data%20model%20is%20the%20Star%20Schema.%20I%20came%20across%20this%20interesting%20diagram...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140442019942%2Fqlikview-lets-get-physical classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/140442019942/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/140442019942/qlikview-lets-get-physical classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/140442019942/C5gpvhK1 classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id140442019942 data-blog-nameipponservices idlike_button_140442019942>iframe idlike_iframe_140442019942 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id140442019942&colorblack&rkC5gpvhK1&slugqlikview-lets-get-physical scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_140442019942>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-140340364062  data-post-id140340364062 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/140340364062/building-strong-foundations-for-qlikview classu-url>Building strong foundations for Qlikview/a>/h2>                                                                                                    div classbody-text e-content>figure data-orig-width548 data-orig-height253 classtmblr-full>img srchttps://64.media.tumblr.com/90eaa6e100f96537fb2978fe3125bf7e/tumblr_inline_o3fb8v8Lj71r8fkpz_640.jpg altimage data-orig-width548 data-orig-height253 width548 height253 />/figure>p>As mentioned in my a hrefhttp://blog.ipponservices.com/post/140208904542/avoiding-qlikview-quicksand>previous post /a>Kimball Dimensional Modelling is the methodology to adopt for building a strong robust data-model foundation for your Qlikview application.br />/p>p>I’m going to use the a hrefhttp://www.gapminder.org/data/>freely available data/a> from a hrefhttp://www.gapminder.org/>Gapminder/a> to create a simple Qlikview application that can replicate some of a hrefhttp://www.bbc.co.uk/news/magazine-24835822>Hans Roslings most memorable findings/a>. /p>p>There are four key steps to take during the Kimball design process :/p>ol>li>Select the business process to be modelled/li>li>Declare the grain/li>li>Identify the dimensions/li>li>Identify the facts/li>/ol>p>b>1. Select the business process to be modelled/b>/p>p>Kimball describes “Business Processes” as the operation activities performed by an organisation. In our example this can be defined as Gapminders stated aim of “promoting a fact based worldview”. I’ll narrow this down either further to address Roslings a hrefhttps://www.ted.com/talks/hans_rosling_shows_the_best_stats_you_ve_ever_seen?languageen>2006 TED talk/a> aim :/p>p>i>Debunking the “us and them” myth of a world divided between “developed” and “developing” nations/i>/p>p>b>2. Declare the Grain/b>/p>p>Grain refers to the lowest level at which data is captured by a given business process. It establishes exactly what a single fact table row represents. Our business process is aiming to compare the facts on Nations over time and therefore the grain of this example will be i>National Statistics per Year./i>/p>p>b>3. Identify the Dimensions /b>br />/p>p>Kimball describe dimensions as i>“the ‘who, what, where, when, why, and how’ context surrounding a business process event.” /i>They can also be described as everything that we know about our defined grain./p>p>Gapminder have compiled a a hrefhttp://www.gapminder.org/data/>treasure trove of data/a> for public consumption at our grain level. Drilling into this data reveals that the dimensions available to us are :/p>ul>li>Countrybr />/li>li>Yearbr />/li>/ul>p>We can the extrapolate further on these dimensions to identify attributes which are relevant for each. For instance for Country this could be Geographic Region, for Year this could be Century. These attributes themselves could be normalised into further dimensions, creating what is know as a Snowflake Schema, but a hrefhttp://www.kimballgroup.com/2008/09/design-tip-105-snowflakes-outriggers-and-bridges/>Kimball advises against this/a>./p>p>b>4. Identify the Facts/b>/p>p>Facts are the measurements that result from a business process event and are almost always numeric.br />/p>p>The source data used by Gapminder to investigate our process can be summarised as “Health & Wealth” and the facts available to us are :/p>ul>li>a hrefhttps://docs.google.com/spreadsheets/d/1PybxH399kK6OjJI4T2M33UsLqgutwj3SuYbk7Yt6sxE/pub?gid0>Income per person/a>br />/li>li>a hrefhttps://docs.google.com/spreadsheets/d/1H3nzTwbn8z4lJ5gJ_WfDgCeGEXK3PVGcNjQ_U5og8eo/pub?gid0>Life Expectancy/a>/li>/ul>p>b>The finalised logical model/b>/p>p>To finalise the design process we can pull together the dimensions and facts into a simple logical model, referred to as a Bubble Chart. /p>figure data-orig-width275 data-orig-height320>img srchttps://64.media.tumblr.com/9b08a2b8f358471fa49fc7ae5a6c9195/tumblr_inline_o3fb39xT411r8fkpz_400.png altimage data-orig-width275 data-orig-height320 width275 height320 />/figure>p>In my next post I’ll be exploring how this logical model can be physically implemented in Qlikview./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/kimball>kimball/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/140340364062/building-strong-foundations-for-qlikview title8 years ago classmeta-item post-date>Mar 2nd, 2016/a>time classdt-published datetime2016-03-02 17:59:13>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_140340364062>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post140340364062>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140340364062%2Fbuilding-strong-foundations-for-qlikview&tBuilding%20strong%20foundations%20for%20Qlikview classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textBuilding%20strong%20foundations%20for%20Qlikview%20-%20As%20mentioned%20in%20my%20previous%20post%20Kimball%20Dimensional%20Modelling%20is%20the%20methodology%20to%20adopt%20for%20building%20a%20strong%20robust%20data-model%20foundation%20for%20your%20Qlikview%20application.%20I%E2%80%99m%20going%20to%20use%20the%20freely...%20https%3A%2F%2Ftmblr.co%2FZUt7nv22iy0CU classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140340364062%2Fbuilding-strong-foundations-for-qlikview classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyBuilding%20strong%20foundations%20for%20Qlikview%20-%20As%20mentioned%20in%20my%20previous%20post%20Kimball%20Dimensional%20Modelling%20is%20the%20methodology%20to%20adopt%20for%20building%20a%20strong%20robust...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140340364062%2Fbuilding-strong-foundations-for-qlikview classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/140340364062/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/140340364062/building-strong-foundations-for-qlikview classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/140340364062/CXJ2eoKl classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id140340364062 data-blog-nameipponservices idlike_button_140340364062>iframe idlike_iframe_140340364062 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id140340364062&colorblack&rkCXJ2eoKl&slugbuilding-strong-foundations-for-qlikview scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_140340364062>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-140208904542  data-post-id140208904542 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/140208904542/avoiding-qlikview-quicksand classu-url>Avoiding Qlikview Quicksand/a>/h2>                                                                                                    div classbody-text e-content>p>Nobody would choose to build their house on quicksand and similarly Qlikview projects can easily run into trouble because of a lack of time spent on building strong foundations./p>figure data-orig-width620 data-orig-height330 classtmblr-full>img srchttps://64.media.tumblr.com/041794e01f0f1a664ae83da5bde01437/tumblr_inline_o3b2h4JCaL1r8fkpz_640.jpg altimage data-orig-width620 data-orig-height330 width620 height330 />/figure>p>The foundation of every Qlikview project is the data-model. Without spending adequate time and effort on getting the data-model correct any attempts to provide useful reporting and insight via the UI is doomed to failure. Regardless of how many amazing visualisations and stunning KPI’s you supply end-users your application will lack robustness. It will be slow, overly complex to develop, lack adaptability and run into real problems as the data inevitably scales. You will watch as all your hard work slowly slips away beneath the quicksand. br />/p>p>To avoid these pitfalls follow the principles of the de facto standard for Business Intelligence data-model design, a hrefhttp://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/>Kimball Dimension Modelling/a> which can easily be applied in Qlikview./p>p>In a nutshell the Kimball design methodology helps you build a data-model that is tailored for :/p>ul>li>b>Speed/b> - Fast retrieval of informationbr />/li>li>b>Understandability/b> - Easy to query and understand for both developers and end users br />/li>li>b>Extensibility/b> - Easily accommodate unexpected new data and reporting requirements/li>/ul>p>The Kimball methodology also helps you create a data-model that is focused on the key goal of any Business Intelligence system, b>it will allow you to understand  your business by making it easy to ask questions of your data/b>./p>p>I’ll be explaining the Kimball design process and how this can be applied to Qlikview using real-world examples in my a hrefhttp://blog.ipponservices.com/post/140340364062/building-strong-foundations-for-qlikview>next post/a>./p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/kimball>kimball/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/business%20intelligence>business intelligence/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/Business%20Discovery>Business Discovery/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/dimensional%20models>dimensional models/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/140208904542/avoiding-qlikview-quicksand title8 years ago classmeta-item post-date>Feb 29th, 2016/a>time classdt-published datetime2016-02-29 12:06:19>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_140208904542>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post140208904542>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140208904542%2Favoiding-qlikview-quicksand&tAvoiding%20Qlikview%20Quicksand classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textAvoiding%20Qlikview%20Quicksand%20-%20Nobody%20would%20choose%20to%20build%20their%20house%20on%20quicksand%20and%20similarly%20Qlikview%20projects%20can%20easily%20run%20into%20trouble%20because%20of%20a%20lack%20of%20time%20spent%20on%20building%20strong%20foundations.%20The%20foundation%20of%20every%20Qlikview...%20https%3A%2F%2Ftmblr.co%2FZUt7nv22b6XbU classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140208904542%2Favoiding-qlikview-quicksand classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyAvoiding%20Qlikview%20Quicksand%20-%20Nobody%20would%20choose%20to%20build%20their%20house%20on%20quicksand%20and%20similarly%20Qlikview%20projects%20can%20easily%20run%20into%20trouble%20because%20of%20a%20lack%20of%20time%20spent...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F140208904542%2Favoiding-qlikview-quicksand classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/140208904542/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/140208904542/avoiding-qlikview-quicksand classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/140208904542/FBCidajU classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id140208904542 data-blog-nameipponservices idlike_button_140208904542>iframe idlike_iframe_140208904542 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id140208904542&colorblack&rkFBCidajU&slugavoiding-qlikview-quicksand scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_140208904542>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classtext not-page post-31517426401  data-post-id31517426401 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                        div classpost-content>                                                h2 classtitle p-name>a hrefhttps://blog.ipponservices.com/post/31517426401/using-qlikview-with-openstreetmap classu-url>Using Qlikview with OpenStreetMap/a>/h2>                                                                                                    div classbody-text e-content>p>Qlikviews ability to overlay dimension and expression values onto maps using extensions is one of the applications great selling points./p>p>However Googles move a hrefhttps://developers.google.com/maps/faq#usagelimits target_blank>to limit its free API usage to 25,000 map loads per day/a> has put the kibosh on any heavy duty commercial usage using the worlds premier online mapping resource./p>p>To the rescue comes a hrefhttp://mindspank.wordpress.com/ target_blank>Alexander Karlsson/a> and a hrefhttp://www.tiq-solutions.de/display/home/Home target_blank>Ralf Becher/a> who have put together a fantastic extension that uses a  completely FREE solution based on CloudMade API’s and OpenStreetMap map-tiles./p>p>Currently it supports placing of markers with custom titles, clustering of markers to support large numbers of markers in the same area, single marker selection support back to QV./p>p>Check it out at: a hrefhttp://community.qlikview.com/message/253809 titlehttp://community.qlikview.com/message/253809 target_blank>http://community.qlikview.com/message/253809/a>/p>p>img height355 srchttp://community.qlikview.com/servlet/JiveServlet/showImage/2-253721-21037/QlikView_foursquare.png width344 altimage styletext-align: middle; />/p>/div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                                                                                                                                                                                                        section classinline-meta post-extra has-source>                                                                                                a classmeta-item source-link hrefhttp://mindspank.wordpress.com/2012/09/13/new-mapping-extension/>Source: mindspank.wordpress.com/a>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/extensions>extensions/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/maps>maps/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/google>google/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/QAR>QAR/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/31517426401/using-qlikview-with-openstreetmap title12 years ago classmeta-item post-date>Sep 14th, 2012/a>time classdt-published datetime2012-09-14 12:14:00>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_31517426401>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post31517426401>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F31517426401%2Fusing-qlikview-with-openstreetmap&tUsing%20Qlikview%20with%20OpenStreetMap classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textUsing%20Qlikview%20with%20OpenStreetMap%20-%20Qlikviews%20ability%20to%20overlay%20dimension%20and%20expression%20values%20onto%20maps%20using%20extensions%20is%20one%20of%20the%20applications%20great%20selling%20points.%20However%20Googles%20move%20to%20limit%20its%20free%20API%20usage%20to%2025%2C000%20map%20loads%20per...%20https%3A%2F%2Ftmblr.co%2FZUt7nvTMbSBX classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F31517426401%2Fusing-qlikview-with-openstreetmap classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20post%20from%20IPPON%20Qlikview%20Blog&bodyUsing%20Qlikview%20with%20OpenStreetMap%20-%20Qlikviews%20ability%20to%20overlay%20dimension%20and%20expression%20values%20onto%20maps%20using%20extensions%20is%20one%20of%20the%20applications%20great%20selling...%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F31517426401%2Fusing-qlikview-with-openstreetmap classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/31517426401/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/31517426401/using-qlikview-with-openstreetmap classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/31517426401/DePoiVcj classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id31517426401 data-blog-nameipponservices idlike_button_31517426401>iframe idlike_iframe_31517426401 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id31517426401&colorblack&rkDePoiVcj&slugusing-qlikview-with-openstreetmap scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_31517426401>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classlink not-page post-29897899043  data-post-id29897899043 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                                                                                                                                                                                                        div classpost-content h-entry>                                                div classlink-wrapper>                                                    a  hrefhttps://www.vizify.com/nikolas-daley classlink u-bookmark-of h-cite>                                                                                                                div classlink-text-wrapper clearfix>                                                            div classlink-text>                                                                                                                                div classlink-host>vizify.com/div>                                                                                                                                h2 classlink-title p-name>Nikolas Daley - Vizify Profile/h2>                                                                                                                                                                                            /div>                                                        /div>                                                    /a>                                                /div>                                                                                                    div classcaption e-summary>                                                                                                            /div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                        section classinline-meta post-extra>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/Nikolas%20Daley>Nikolas Daley/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/29897899043/nikolasdaleyvizify title12 years ago classmeta-item post-date>Aug 21st, 2012/a>time classdt-published datetime2012-08-21 15:26:00>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_29897899043>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post29897899043>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29897899043%2Fnikolasdaleyvizify&tIPPON%20Qlikview%20Blog classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?textNikolas%20Daley%20-%20Vizify%20Profile%20https%3A%2F%2Ftmblr.co%2FZUt7nvRs3RmZ classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29897899043%2Fnikolasdaleyvizify classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20link%20from%20IPPON%20Qlikview%20Blog&bodyNikolas%20Daley%20-%20Vizify%20Profile%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29897899043%2Fnikolasdaleyvizify classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/29897899043/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/29897899043/nikolasdaleyvizify classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/29897899043/J5aThXyQ classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id29897899043 data-blog-nameipponservices idlike_button_29897899043>iframe idlike_iframe_29897899043 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id29897899043&colorblack&rkJ5aThXyQ&slugnikolasdaleyvizify scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_29897899043>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                        article classlink not-page post-29889290667  data-post-id29889290667 >                                    div classpost-wrapper clearfix h-entry>                                        header classpost-header >                                                                                                                                                                            /header>                                        section classpost>                                                                                                                                                                                                                                                                        div classpost-content h-entry>                                                div classlink-wrapper>                                                    a  hrefhttp://www.quickintelligence.co.uk/qlikview-design/ classlink u-bookmark-of h-cite>                                                                                                                div classlink-text-wrapper clearfix>                                                            div classlink-text>                                                                                                                                div classlink-host>quickintelligence.co.uk/div>                                                                                                                                h2 classlink-title p-name>5 Qlikview Dashboard Design Tips/h2>                                                                                                                                                                                            /div>                                                        /div>                                                    /a>                                                /div>                                                                                                    div classcaption e-summary>                                                                                                            /div>                                                                                                                                            /div>                                                                                                                                                                                                                                                                        section classinline-meta post-extra has-source>                                                                                                a classmeta-item source-link hrefhttp://www.quickintelligence.co.uk>Source: quickintelligence.co.uk/a>                                                                                            /section>                                            section classinline-meta post-extra has-tags>                                                                                                                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/qlikview>qlikview/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/tips>tips/a>                                                                                                             a classmeta-item tag-link p-category hrefhttps://blog.ipponservices.com/tagged/dashboard>dashboard/a>                                                                                                                                                /section>                                        /section>                                                                                section classpanel>                                            footer classpost-footer>                                                section classpanel>                                                    section classinline-meta date-notes>                                                        div classdate-note-wrapper>                                                                                                                        a hrefhttps://blog.ipponservices.com/post/29889290667/5-qlikview-dashboard-design-tips title12 years ago classmeta-item post-date>Aug 21st, 2012/a>time classdt-published datetime2012-08-21 10:16:00>/time>                                                        /div>                                                    /section>                                                    section classpost-controls>                                                        div classcontrols-wrapper>                                                            div classcontrol share-control>                                                                nav classpop>                                                                    a href# classshare selector>/a>                                                                    div classpop-menu share-menu south idshare_29889290667>                                                                        ul>                                                                            li classopen-in-app>a href# classshare-item open-in-app data-post29889290667>Open in app/a>/li>                                                                            li>a hrefhttps://facebook.com/sharer.php?uhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29889290667%2F5-qlikview-dashboard-design-tips&tIPPON%20Qlikview%20Blog classshare-item facebook target_blank>Facebook/a>/li>                                                                            li>a hrefhttps://twitter.com/intent/tweet?text5%20Qlikview%20Dashboard%20Design%20Tips%20https%3A%2F%2Ftmblr.co%2FZUt7nvRrYc6h classshare-item twitter target_blank>Tweet/a>/li>                                                                                                                                                                                                                                    li>a hrefhttps://reddit.com/submit?urlhttps%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29889290667%2F5-qlikview-dashboard-design-tips classshare-item reddit target_blank>Reddit/a>/li>                                                                            li>a hrefmailto:?subjectA%20link%20from%20IPPON%20Qlikview%20Blog&body5%20Qlikview%20Dashboard%20Design%20Tips%20https%3A%2F%2Fblog.ipponservices.com%2Fpost%2F29889290667%2F5-qlikview-dashboard-design-tips classshare-item mail>Mail/a>/li>                                                                            li>a hrefhttps://ipponservices.tumblr.com/post/29889290667/embed classshare-item permalink>Embed/a>/li>                                                                            li>a hrefhttps://blog.ipponservices.com/post/29889290667/5-qlikview-dashboard-design-tips classshare-item permalink>Permalink i classarrow>/i>/a>/li>                                                                        /ul>                                                                    /div>                                                                /nav>                                                            /div>                                                            div classcontrol reblog-control>a hrefhttps://www.tumblr.com/reblog/ipponservices/29889290667/EsY7TYO2 classreblog_buttonstyledisplay: block;width:24px;height:24px;>svg width100% height100% viewBox0 0 21 21 xmlnshttp://www.w3.org/2000/svg xmlns:xlinkhttp://www.w3.org/1999/xlink fill#000>path dM5.01092527,5.99908429 L16.0088498,5.99908429 L16.136,9.508 L20.836,4.752 L16.136,0.083 L16.1360004,3.01110845 L2.09985349,3.01110845 C1.50585349,3.01110845 0.979248041,3.44726568 0.979248041,4.45007306 L0.979248041,10.9999998 L3.98376463,8.30993634 L3.98376463,6.89801007 C3.98376463,6.20867902 4.71892527,5.99908429 5.01092527,5.99908429 Z>/path>path dM17.1420002,13.2800293 C17.1420002,13.5720293 17.022957,14.0490723 16.730957,14.0490723 L4.92919922,14.0490723 L4.92919922,11 L0.5,15.806 L4.92919922,20.5103758 L5.00469971,16.9990234 L18.9700928,16.9990234 C19.5640928,16.9990234 19.9453125,16.4010001 19.9453125,15.8060001 L19.9453125,9.5324707 L17.142,12.203>/path>/svg>/a>/div>                                                            div classcontrol like-control>div classlike_button data-post-id29889290667 data-blog-nameipponservices idlike_button_29889290667>iframe idlike_iframe_29889290667 srchttps://assets.tumblr.com/assets/html/like_iframe.html?_vc96f30edcf75919c3976e1403422560b#nameipponservices&post_id29889290667&colorblack&rkEsY7TYO2&slug5-qlikview-dashboard-design-tips scrollingno width24 height24 frameborder0 classlike_toggle allowTransparencytrue namelike_iframe_29889290667>/iframe>/div>/div>                                                        /div>                                                    /section>                                                /section>                                                section classinline-meta date-notes>                                                                                                        /section>                                            /footer>                                        /section>                                                                                                                    /div>                                /article>                                                                                                                                                                        /div> !-- .main -->                    div classsidebar>                                                                    /div> !-- .sidebar -->                /div> !-- .container -->            /section>                        footer idfooter classcontent clearfix>                                                        div idpagination>                                                                        a href/page/2 classnext data-current-page1 data-total-pages4>Nextspan classbg>/span>/a>                                                div classloader>div classloader-bar>/div>div classloader-bar>/div>div classloader-bar>/div>/div>                    /div>                                                /footer>        /section>        script>            var Optica  {};            Optica.ENDLESS_SCROLLING  true;            Optica.SHOW_NAV  true;            Optica.LAYOUT  regular;            Optica.GRID_LAYOUT  (Optica.LAYOUT  grid);            Optica.TITLE_COLOR  #444444;            Optica.ACCENT_COLOR  #529ECC;            Optica.BACKGROUND_COLOR  #FAFAFA;                            Optica.NU_OPTICA_BLOG_CARDS  true;                                    Optica.RELATED_POSTS_CTA_VARIANTS                 {                   variant: C,                   text: See the rest of this Tumblr               },               {                   variant: D,                   text: See ipponservicess whole Tumblr               },               {                   variant: E,                   text: You scrolled this far. Check out the rest.               }            ;            Optica.NO_LIKES_VARIANTS                  This Tumblr hasnt liked any posts yet.,                This Tumblr doesnt like anything…yet.,                No likes! Sheesh!,                Amazing! This Tumblr doesnt like anything.,                Incredible! This Tumblr doesnt like anything.,                Neat! This Tumblr doesnt like anything.,                Apparently this Tumblr is hard to please.,                Wow! This Tumblr hasnt liked anything ever.,                This Tumblr hasnt liked anything yet. How very intriguing.,                This Tumblr has never met a post it didnt not like.            ;            Optica.NO_POSTS_VARIANTS                  This Tumblr hasnt made any posts.,                This silly Tumblr hasnt posted anything yet.,                This Tumblr is cool, but empty.,                This Tumblr is content-free.,                This minimalist Tumblr has no posts.,                Meditate for a while on this empty Tumblr.,                Posts? Nah.,                This Tumblr has hardly any posts. \nNone at all, in fact.,                This Tumblr hasnt posted anything.            ;            Optica.NO_FOLLOWING_VARIANTS                  This Tumblr hasnt followed any other Tumblrs.,                Aw. This Tumblr isnt following anyone.,                Nope, this Tumblr doesnt follow anyone.,                This cool Tumblr doesnt follow anyone.,                This far-out Tumblr doesnt follow anyone.,                This fiercely independent Tumblr doesnt follow anyone.,                This Tumblr doesnt follow anything except for its own rules.,                This Tumblr doesnt really \follow\ anything.            ;        /script>        script srchttps://assets.tumblr.com/default-theme/r1/main-min.js>/script>                                                iframe scrollingno width1 height1 frameborder0 stylebackground-color:transparent; overflow:hidden; position:absolute; top:0; left:0; z-index:9999; idga_target>/iframe>script typetext/javascript>    (function(){        var analytics_frame  document.getElementById(ga_target);        var analytics_iframe_loaded;        var user_logged_in;        var blog_is_nsfw  No;        var eventMethod  window.addEventListener ? addEventListener : attachEvent;        var eventer  windoweventMethod;        var messageEvent  eventMethod  attachEvent ? onmessage : message;        eventer(messageEvent,function(e) {            var message  (e.data && e.data.split) ? e.data.split(;) : ;            switch (message0) {                case analytics_iframe_loaded:                    analytics_iframe_loaded  true;                    postCSMessage();                    postGAMessage();                    break;                case user_logged_in:                    user_logged_in  message1;                    postGAMessage();                    break;            }        }, false);        analytics_frame.src  https://assets.tumblr.com/analytics.html?_v9f5febfd57a8a649c598d888f2d9e062# +                              https://blog.ipponservices.com;        function postGAMessage() {            if (analytics_iframe_loaded && user_logged_in) {                var is_ajax  false;                analytics_frame.contentWindow.postMessage(tick_google_analytics, is_ajax, user_logged_in, blog_is_nsfw, /?route%2F.join(;), analytics_frame.src.split(/analytics.html)0);            }        }        function postCSMessage() {            COMSCORE  true;            analytics_frame.contentWindow.postMessage(enable_comscore; + window.location, analytics_frame.src.split(/analytics.html)0);        }    })();/script>script typetext/javascript nonce3dBCnSk5hAwhQ40bOXcHTqzQ9EY>!function(s){s.srchttps://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoidXJsIiwidXJsIjoiaHR0cDovL2Jsb2cuaXBwb25zZXJ2aWNlcy5jb20vIiwicmVxdHlwZSI6MCwicm91dGUiOiIvIn0&UPJNONGLLMP&Kd3541b75415efeebb653aad1007aea022708485656275d1e67ef7bab896d66be&R.replace(/&R^&$*/,).concat(&R+escape(document.referrer)).slice(0,2000).replace(/%.?.?$/,);}(new Image());/script>noscript>img styleposition:absolute;z-index:-3334;top:0px;left:0px;visibility:hidden; srchttps://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoidXJsIiwidXJsIjoiaHR0cDovL2Jsb2cuaXBwb25zZXJ2aWNlcy5jb20vIiwicmVxdHlwZSI6MCwicm91dGUiOiIvIiwibm9zY3JpcHQiOjF9&UPJNONGLLMP&Ke6408d39149168bbf6eae5d0d2285df11e3dc9fa9bb7e825a5ed658982763a15&R>/noscript>script typetext/javascript nonce3dBCnSk5hAwhQ40bOXcHTqzQ9EY>!function(s){s.srchttps://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoicG9zdCIsInVybCI6Imh0dHA6Ly9ibG9nLmlwcG9uc2VydmljZXMuY29tLyIsInJlcXR5cGUiOjAsInJvdXRlIjoiLyIsInBvc3RzIjpbeyJwb3N0aWQiOiIxNDE0ODc0NzQwODciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjE0MTIwNTYyODI2MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQxMDMwNzM5Nzc3IiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDA4NDY3Nzc2MTciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjE0MDQ0MjAxOTk0MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQwMzQwMzY0MDYyIiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDAyMDg5MDQ1NDIiLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjMxNTE3NDI2NDAxIiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIyOTg5Nzg5OTA0MyIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMjk4ODkyOTA2NjciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfV19&UIBLFJJOJLE&K096cd0d666fead31e4793773599a518cdb9662be3f76d86769ac8184190ca155&R.replace(/&R^&$*/,).concat(&R+escape(document.referrer)).slice(0,2000).replace(/%.?.?$/,);}(new Image());/script>noscript>img styleposition:absolute;z-index:-3334;top:0px;left:0px;visibility:hidden; srchttps://px.srvcs.tumblr.com/impixu?T1731750641&JeyJ0eXBlIjoicG9zdCIsInVybCI6Imh0dHA6Ly9ibG9nLmlwcG9uc2VydmljZXMuY29tLyIsInJlcXR5cGUiOjAsInJvdXRlIjoiLyIsInBvc3RzIjpbeyJwb3N0aWQiOiIxNDE0ODc0NzQwODciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjE0MTIwNTYyODI2MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQxMDMwNzM5Nzc3IiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDA4NDY3Nzc2MTciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjE0MDQ0MjAxOTk0MiIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMTQwMzQwMzY0MDYyIiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIxNDAyMDg5MDQ1NDIiLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfSx7InBvc3RpZCI6IjMxNTE3NDI2NDAxIiwiYmxvZ2lkIjo0NzM5OTc3NCwic291cmNlIjozM30seyJwb3N0aWQiOiIyOTg5Nzg5OTA0MyIsImJsb2dpZCI6NDczOTk3NzQsInNvdXJjZSI6MzN9LHsicG9zdGlkIjoiMjk4ODkyOTA2NjciLCJibG9naWQiOjQ3Mzk5Nzc0LCJzb3VyY2UiOjMzfV0sIm5vc2NyaXB0IjoxfQ&UIBLFJJOJLE&Kcc98e11defb2628376ea9eef77d5bcb434130df2b9aa6413d7b78e3550de227d&R>/noscript>noscript idbootloader data-bootstrap{"Components":{"PostActivity":,"NotificationPoller":{"messaging_keys":,"token":"","inbox_unread":0},"DesktopDashboardLogo":{"animations":"https:\/\/assets.tumblr.com\/images\/logo\/hover-animations\/1.png?_v161861acded461bb6e995593a3bae835","https:\/\/assets.tumblr.com\/images\/logo\/hover-animations\/1@2x.png?_v496a774637302a598c851381d00009b0"},"TumblelogIframe":{"unified":true,"variant":null,"isCompact":false,"tumblelogBundleSrc":"https:\/\/assets.tumblr.com\/client\/prod\/standalone\/tumblelog\/index.build.js?_v03e800b27eff76cee863b8346f5e3e52","tumblelogName":"ipponservices","isLoggedIn":false,"isFriend":false,"formKey":"","canSubscribe":false,"isSubscribed":false,"tumblelogTitle":"IPPON Qlikview Blog","tumblelogAvatar":"https:\/\/64.media.tumblr.com\/avatar_f141d3edbc15_64.pnj","tumblelogAvatar128":"https:\/\/64.media.tumblr.com\/avatar_f141d3edbc15_128.pnj","tumblelogHost":"https:\/\/blog.ipponservices.com","hasCustomDomain":true,"isOptica":true,"isCustomTheme":false,"themeHeaderImage":"https:\/\/static.tumblr.com\/3b975cedd10907468133305a34b37162\/zcdpezf\/UCZo3icm0\/tumblr_static_6kbnzikxf64ocsc0480gcog8s_2048_v2.png","themeBackgroundColor":"#FAFAFA","themeTitleColor":"#444444","themeAccentColor":"#529ECC","brag":false,"canShowAd":true,"isPremium":false,"showLrecAds":false,"showStickyLrecBackfill":false,"showGeminiAds":false,"geminiSectionCodeDesktop":"a10bca9c-0c5d-4a02-ab13-14ab8513d81d","geminiSectionCodeMobile":"ced63809-b609-4aca-96a0-abc099acba6b","currentPageType":"blog","currentPage":1,"searchQuery":"","tag":"","query":"","chrono":false,"postId":"","src":"https:\/\/blog.ipponservices.com\/","postUrl":"","openInPeeprUrl":"https:\/\/www.tumblr.com\/ipponservices","isBlocked":null,"isAdmin":false,"lookupButtonUrl":"","showSpamButton":false,"showRootPostButton":false,"rootPostUrl":"","showRadarPostButton":false,"radarKeys":"","isUniblocked":false,"isNsfw":false,"isAdult":false,"isSpam":false,"isPrimaryBlog":false,"canEdit":false,"canReblogSelf":false,"showLikeButton":false,"showReblogButton":false,"reblogUrl":"","showMessagingButton":false,"loginCheckIframeSrc":"https:\/\/assets.tumblr.com\/assets\/html\/iframe\/login_check.html?_v3de94a184d600617102ddd5b48fb36e9","appInstallUrls":{"android":"https:\/\/play.google.com\/store\/apps\/details?idcom.tumblr\u0026referrerutm_source%3Dtumblr%26utm_medium%3Diframe%26utm_campaign%3Dbn_continue_or_install_cta","ios":"https:\/\/apps.apple.com\/app\/apple-store\/id305343404?pt212308\u0026ctbn_continue_or_install_cta\u0026mt8"},"appOpenReferrer":"bn_header_open_btn","isShowSearch":true,"supplyLogging":,"secondsSinceLastActivity":-1,"installUrlOpenFailed":{"android":"https:\/\/play.google.com\/store\/apps\/details?idcom.tumblr\u0026referrerutm_source%3Dtumblr%26utm_medium%3Diframe%26utm_campaign%3Dbn_header_app_open_failed","ios":"https:\/\/apps.apple.com\/app\/apple-store\/id305343404?pt212308\u0026ctbn_header_app_open_failed\u0026mt8"},"loginWallVariant":"small_center"},"CommunityLabels":{"has_community_label":false,"is_single":false,"redirect_target":null}},"Flags":{"features":"eyJmaWx0ZXJfbnNmdyI6dHJ1ZSwibW9iaWxlX3dlYl9nYXRlIjp0cnVlLCJzYWZlX21vZGUiOnRydWUsInNhZmVfbW9kZV9lbmFibGVkIjp0cnVlLCJrZXljb21tYW5kX2F1dG9fcGFnaW5hdGUiOnRydWUsImxvZ2dlZF9vdXRfc2VhcmNoIjp0cnVlLCJrcmFrZW5fd2ViX2xvZ2dpbmdfbGlicmFyeSI6dHJ1ZSwibGl2ZXBob3Rvc193ZWIiOnRydWUsInVzZXJfdGFnX2ZpbHRlcmluZyI6dHJ1ZSwic2FmZV9tb2RlX293bl9wb3N0Ijp0cnVlLCJwcm9qZWN0X3hfYXBwZWFsIjp0cnVlLCJtb2JpbGVfd2ViX3Bob3Rvc2V0cyI6dHJ1ZSwiaGlkZV9kZWZhdWx0X2hlYWRlcnNfYmxvZ19jYXJkcyI6dHJ1ZSwibm90aWZpY2F0aW9uX3JlcGx5X2xpbmtfdG9fbm90ZXMiOnRydWUsInR5cGluZ19pbmRpY2F0b3Jfd3JpdGUiOnRydWUsInR1bWJscl92aWRlb19zcG9uc29yZWRfZGF5Ijp0cnVlLCJjYXB0Y2hhOnVzZV9yZWNhcHRjaGEyIjp0cnVlLCJsaXR0bGVfc2lzdGVyIjp0cnVlLCJsb2dfbGFkeSI6dHJ1ZSwicmVkcG9wX3Bvc3RfZm9ybV9tb2JpbGVfY3JlYXRlIjp0cnVlLCJsZWdhY3lfcG9zdF9mb3JtX2J1dHRvbnNfbGlua190b19yZWRwb3AiOnRydWUsInNob3dfdHNwX2NsaWNrX3Rocm91Z2hfdG9nZ2xlIjp0cnVlLCJkYXJsYV9hZF9mZWVkYmFjayI6dHJ1ZSwic3RhdHVzX2luZGljYXRvciI6dHJ1ZSwiY29udmVyc2F0aW9uYWxfbm90aWZpY2F0aW9ucyI6dHJ1ZSwiZGlzYWJsZV95YWhvb19iX2Nvb2tpZSI6dHJ1ZSwibGl2ZXBob3RvcyI6dHJ1ZSwiY29tbXVuaXR5X2xhYmVscyI6dHJ1ZX0"},"Context":{"name":"default","time":1731750641000,"userinfo":{"primary":"","name":"","channels":},"hosts":{"assets_host":"https:\/\/assets.tumblr.com","secure_assets_host":"https:\/\/assets.tumblr.com","www_host":"https:\/\/www.tumblr.com","secure_www_host":"https:\/\/www.tumblr.com","embed_host":"https:\/\/embed.tumblr.com","safe_host":"https:\/\/safe.txmblr.com","platform_host":"https:\/\/platform.tumblr.com"},"language":"en_US","language_simple":"en","assets":"https:\/\/assets.tumblr.com\/client\/prod\/"},"Translations":{"%1$sReport %2$s's post?%3$sIf it violates our user guidelines, we'll remove it.%4$s":"%1$sReport %2$s's reblog?%3$sIf it violates our user guidelines, we'll remove it.%4$s","%1$sReport %2$s's reply?%3$sIf it violates our user guidelines, we'll remove it.%4$s":"%1$sReport %2$s's reblog?%3$sIf it violates our user guidelines, we'll remove it.%4$s","%1$sDelete your tip??%2$s":"%1$sDelete your tip?%2$s","Deleting your tip":"Deleting your tip will only remove it from the replies tab and notes. %1$sYou won't receive a refund of your tip.%2$s For further help contact %3$sTumblr Support%4$s."}}>/noscript>script srchttps://assets.tumblr.com/client/prod/standalone/tumblelog/index.build.js?_v03e800b27eff76cee863b8346f5e3e52>/script>/body>/html>

View on OTX | View on ThreatMiner

Data with thanks to AlienVault OTX, VirusTotal, Malwr and others. [Sitemap]

Domain > blog.ipponservices.com

Is this malicious?

Whois

DNS Resolutions

Port 80

Port 443