{"id":4483,"date":"2015-04-07T06:57:00","date_gmt":"2015-04-07T04:57:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/"},"modified":"2015-04-07T06:57:00","modified_gmt":"2015-04-07T04:57:00","slug":"qliksense-the-easy-way-to-create-a-qlikview-report","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/","title":{"rendered":"QlikSense \u2013 The easy way to create a QlikView report"},"content":{"rendered":"<p>Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years.<\/p>\n<p style=\"margin-bottom: 0.0001pt; line-height: normal; text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"BI-Gartner-201502.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\"><img loading=\"lazy\" decoding=\"async\" title=\"BI-Gartner-201502.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\" alt=\"BI-Gartner-201502.png\" width=\"434\" height=\"467\" \/><\/a><\/p>\n<p>To make Business Intelligence even more accessible to Business users, the Qlik Company decided to add an additional product in its range. This product should be more accessible and easier to use to create analytics reports. That\u2019s why QlikSense was created.<\/p>\n<h3 style=\"padding-left: 30px;\">1.Build a report in a few mouse clicks<\/h3>\n<p>One of the great strengths of QlikView is that the use of an analytical report has become very simple. The user of a QlikView report need only to select the various criteria they wish to apply to these tables and graphs so that they are automatically adapted to the application.<\/p>\n<p style=\"margin-bottom: 0.0001pt; line-height: normal; text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"report_qlikview.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/report_qlikview.png\"><img loading=\"lazy\" decoding=\"async\" title=\"report_qlikview.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/report_qlikview.png\" alt=\"report_qlikview.png\" width=\"390\" height=\"409\" \/><\/a><\/p>\n<p>In this case, the user has just clicked on the criteria &#8220;Argentina&#8221; and all report data has been filtered to show only the data for this country.<br \/>\nHowever, the construction of a QlikView\u2019s report is not so simple. The multitude of options available for creating each artifact can quickly become quite complex. This makes the end user still dependent on the developer&#8217;s report both for its construction than for any changes they would make.<br \/>\nTo make the creation of these reports more accessible to the majority, Qlik decided to launch Qlik Sence. This product brings simplicity in building reports because it\u2019s using the Drag and Drop technology. The user can now create his tables and charts using only the mouse, making the creation of a report as easy as in Excel.<br \/>\nTo create a new report in QlikSense, click &#8220;Create a new App&#8221;<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-2.png\"><img loading=\"lazy\" decoding=\"async\" title=\"1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-2.png\" alt=\"1.png\" width=\"93\" height=\"49\" \/><\/a><\/p>\n<p>Give the new application a name and click \u00ab\u00a0Create\u00a0\u00bb<\/p>\n<pre><a class=\"easyblog-thumb-preview\" title=\"2_20150331-072751_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2_20150331-072751_1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"2_20150331-072751_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2_20150331-072751_1.png\" alt=\"2_20150331-072751_1.png\" width=\"363\" height=\"94\" \/><\/a><\/pre>\n<p>Click on \u00ab\u00a0Open\u00bb<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"3.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"3.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/3-1.png\" alt=\"3.png\" width=\"363\" height=\"64\" \/><\/a><\/p>\n<p>As in any QlikView report, the first thing to do is to retrieve data. There are two options to do that:<br \/>\n&#8220;Quick Data Load&#8221; or &#8221; Load Data Editor.&#8221;<\/p>\n<ul>\n<li>\u201cQuick Data Load&#8221; allows you to select any data coming from a flat file or located in a XLS sheet.<\/li>\n<li>&#8220;Data Load Editor&#8221; allows you to create more complex data sources based on SQL -type queries<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"4_20150331-073800_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4_20150331-073800_1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"4_20150331-073800_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/4_20150331-073800_1.png\" alt=\"4_20150331-073800_1.png\" width=\"270\" height=\"155\" \/><\/a><\/p>\n<p>For our example, we are using \u00ab\u00a0Data Load Editor\u00a0\u00bb. After opening the application, you should only select the data source connector you want to use and set up your connection to your data source.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"5.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/5-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"5.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/5-1.png\" alt=\"5.png\" width=\"264\" height=\"191\" \/><\/a><\/p>\n<p>I will created later a new blog focused on the creation and the setup of data connection in QlikView and QlikSense.<br \/>\nIn this case, we will use a .qvx file type. Such files are created through the QlikView ETL application called &#8220;QlikView Expressor &#8220;.<br \/>\nThe load script is then displayed on the screen in SQL format.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"6.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/6-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"6.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/6-1.png\" alt=\"6.png\" width=\"311\" height=\"226\" \/><\/a><\/p>\n<p>You just have to launch the data load.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"7.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/7-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"7.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/7-1.png\" alt=\"7.png\" width=\"213\" height=\"92\" \/><\/a><\/p>\n<p>When it\u2019s done, you should activate the \u00ab\u00a0App Overview\u00a0\u00bb mode.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"8.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8-1.png\" alt=\"8.png\" width=\"349\" height=\"101\" \/><\/a><\/p>\n<p>Then, the user can create a new sheet:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"9.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/9.png\"><img loading=\"lazy\" decoding=\"async\" title=\"9.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/9.png\" alt=\"9.png\" width=\"328\" height=\"153\" \/><\/a><\/p>\n<p>He gives it a name and click on it.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"10.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/10.png\"><img loading=\"lazy\" decoding=\"async\" title=\"10.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/10.png\" alt=\"10.png\" width=\"324\" height=\"173\" \/><\/a><\/p>\n<p>To display the \u00ab\u00a0Edit\u00a0\u00bb mode, you just have to click on this icon:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"11.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/11.png\"><img loading=\"lazy\" decoding=\"async\" title=\"11.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/11.png\" alt=\"11.png\" width=\"397\" height=\"208\" \/><\/a><\/p>\n<p>At this point, the user can create his graphic using the Drag and drop mode<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"drag_drop.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/drag_drop.png\"><img loading=\"lazy\" decoding=\"async\" title=\"drag_drop.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/drag_drop.png\" alt=\"drag_drop.png\" width=\"313\" height=\"327\" \/><\/a><\/p>\n<p>After chosen the chart type, select your dimensions and measures<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"select_dim.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/select_dim.png\"><img loading=\"lazy\" decoding=\"async\" title=\"select_dim.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/select_dim.png\" alt=\"select_dim.png\" width=\"302\" height=\"223\" \/><\/a><\/p>\n<p>And that\u2019s the result.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"graph.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/graph.png\"><img loading=\"lazy\" decoding=\"async\" title=\"graph.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/graph.png\" alt=\"graph.png\" width=\"375\" height=\"257\" \/><\/a><\/p>\n<p>Despite its simplicity, Qlik Sence retains the power of creating and setting chart from QlikView. But the bulk of operations is now made via selection of options, making much easier to create different artifacts.<\/p>\n<h3 style=\"padding-left: 30px;\">2.Type &#8220;Map&#8221; chart<\/h3>\n<p>Qlik has not only added the notion of Drag and Drop. One of the great innovations in QlikSense regards the possibility to create very easily a type &#8220;Map&#8221; chart, that is to say containing geographical information. It was quite difficult to do it in QlikView because it required the use of fairly complex calculated variables. With QlikSense, you just have to use the type &#8220;Map&#8221; object specially created for this purpose and complete the requested information.<br \/>\nTo create a chart &#8220;Map&#8221;, select the chart type &#8220;Map&#8221;<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"geo_graph_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"geo_graph_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_1.png\" alt=\"geo_graph_1.png\" width=\"343\" height=\"259\" \/><\/a><\/p>\n<p>The only constraint to achieve this kind of graph is to have a GeoMakePoint type object. It is created by combining two geolocation information type objects (latitude and longitude).<br \/>\nIn the example below, the object GeoMakePoint &#8220;Location&#8221; is the location of cities.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"makepoint.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/makepoint.png\"><img loading=\"lazy\" decoding=\"async\" title=\"makepoint.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/makepoint.png\" alt=\"makepoint.png\" width=\"163\" height=\"249\" \/><\/a><\/p>\n<p>Click in the &#8221; Layers &#8221; menu. In the &#8220;Add Layers &#8221; box, insert the GeoMakePoint object you just have created. And in the &#8220;Expression&#8221; box, add an aggregate expression.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"geo_graph_7.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_7.png\"><img loading=\"lazy\" decoding=\"async\" title=\"geo_graph_7.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_7.png\" alt=\"geo_graph_7.png\" width=\"243\" height=\"199\" \/><\/a><\/p>\n<p>Then, go to the &#8220;Background&#8221; menu, select the Slippy map server you want to use and copy the URL and the duties of the selected server<br \/>\n<a class=\"easyblog-thumb-preview\" title=\"geo_graph_8.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_8.png\"><img loading=\"lazy\" decoding=\"async\" title=\"geo_graph_8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_8.png\" alt=\"geo_graph_8.png\" width=\"266\" height=\"196\" \/><\/a><br \/>\nSmall comment: All Slippy Map servers can be used by QlikSense. They are listed on the website of QlikView. To access it, simply click on the hyperlink &#8220;URL and Allocation&#8221;.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"geo_graph_4.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_4.png\"><img loading=\"lazy\" decoding=\"async\" title=\"geo_graph_4.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_4.png\" alt=\"geo_graph_4.png\" width=\"364\" height=\"362\" \/><\/a><\/p>\n<p>To activate the different colors from your dimensions on the map, go in the menu \u00ab\u00a0Apparence\u00a0\u00bb and choose the following options:<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"geo_graph_9.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_9.png\"><img loading=\"lazy\" decoding=\"async\" title=\"geo_graph_9.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/geo_graph_9.png\" alt=\"geo_graph_9.png\" width=\"359\" height=\"240\" \/><\/a><\/p>\n<p>Final result will be displayed on a map. Points are the dimension \u201ccity\u201d and the size of the point will be the measure (Sum(Profit)).<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"map.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/map.png\"><img loading=\"lazy\" decoding=\"async\" title=\"map.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/map.png\" alt=\"map.png\" width=\"334\" height=\"193\" \/><\/a><\/p>\n<p>This chart is as interactive as the other, it will also apply the filters selected by the user.<\/p>\n<h3 style=\"padding-left: 30px;\">3.The mode &#8220;Story&#8221;<\/h3>\n<p>QlikSense also offers the possibility to create &#8220;Stories&#8221;, a kind of Microsoft Powerpoint presentation. A &#8220;Story&#8221; is simply a result of various reports that have been fixed with the values that the user wishes to highlight. These presentations can also contain some kind of animation options from those used in Microsoft Powerpoint. These Stories are built from existing QlikSense reports on which the user takes a snapshot after having applied the desired filter.<br \/>\nTo create a &#8220;Story&#8221; , simply activate the &#8220;App Overview&#8221; mode.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"8.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8-1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/8-1.png\" alt=\"8.png\" width=\"394\" height=\"114\" \/><\/a><\/p>\n<p>Then select the \u00ab\u00a0story\u00a0\u00bb mode and click on \u00ab\u00a0new story\u00a0\u00bb.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"12_20150331-081429_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/12_20150331-081429_1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"12_20150331-081429_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/12_20150331-081429_1.png\" alt=\"12_20150331-081429_1.png\" width=\"216\" height=\"146\" \/><\/a><\/p>\n<p>Give it a name, push \u00ab\u00a0Enter\u00a0\u00bb and click on the story.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"13.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/13.png\"><img loading=\"lazy\" decoding=\"async\" title=\"13.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/13.png\" alt=\"13.png\" width=\"334\" height=\"121\" \/><\/a><\/p>\n<p>Before creating the story, you should have taken snapshots from other sheets.<br \/>\n<strong>Warning\u00a0:<\/strong> You can\u2019t insert snapshots located in some other QlikSense applications.<br \/>\nTo create a snapshot, open a Qliksense sheet located in your application.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"14.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/14.png\"><img loading=\"lazy\" decoding=\"async\" title=\"14.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/14.png\" alt=\"14.png\" width=\"396\" height=\"281\" \/><\/a><\/p>\n<p>Open the story you have made and insert the snapshots you need.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"15.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/15.png\"><img loading=\"lazy\" decoding=\"async\" title=\"15.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/15.png\" alt=\"15.png\" width=\"403\" height=\"184\" \/><\/a><\/p>\n<p>You can add some text zones, Microsoft Powerpoint animations, special forms and media objects.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"16.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/16.png\"><img loading=\"lazy\" decoding=\"async\" title=\"16.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/16.png\" alt=\"16.png\" width=\"139\" height=\"188\" \/><\/a><\/p>\n<p>And that\u2019s the final result.<\/p>\n<p style=\"text-align: justify;\"><a class=\"easyblog-thumb-preview\" title=\"17.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/17.png\"><img loading=\"lazy\" decoding=\"async\" title=\"17.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/17.png\" alt=\"17.png\" width=\"529\" height=\"310\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">In conclusion, we can say that QlikView and QlikSense are complementary products that are not reserved to the same type of user.<\/p>\n<ul>\n<li>QlikSense is easier to handle and is designed especially for use as a dashboarding tool<\/li>\n<li>Using HTML 5 technology, it allows you to create reports for any kind of devices<\/li>\n<li>Map type graphs are easier to create<\/li>\n<li>You can create Stories<\/li>\n<\/ul>\n<p><span style=\"line-height: 1.5;\">So we can say that QlikSense will be more easily used by the Business than QlikView because of its friendliness to use.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":4484,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[525],"tags":[210,550,540,264],"type_dbi":[],"class_list":["post-4483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-content-management","tag-business-intelligence","tag-qliksense","tag-qlikview","tag-reporting-services"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>QlikSense \u2013 The easy way to create a QlikView report - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikSense \u2013 The easy way to create a QlikView report\" \/>\n<meta property=\"og:description\" content=\"Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-07T04:57:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\" \/>\n\t<meta property=\"og:image:width\" content=\"764\" \/>\n\t<meta property=\"og:image:height\" content=\"823\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"QlikSense \u2013 The easy way to create a QlikView report\",\"datePublished\":\"2015-04-07T04:57:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\"},\"wordCount\":1111,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\",\"keywords\":[\"Business Intelligence\",\"QlikSense\",\"QlikView\",\"Reporting services\"],\"articleSection\":[\"Enterprise content management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\",\"name\":\"QlikSense \u2013 The easy way to create a QlikView report - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\",\"datePublished\":\"2015-04-07T04:57:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png\",\"width\":764,\"height\":823},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"QlikSense \u2013 The easy way to create a QlikView report\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"QlikSense \u2013 The easy way to create a QlikView report - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/","og_locale":"en_US","og_type":"article","og_title":"QlikSense \u2013 The easy way to create a QlikView report","og_description":"Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/","og_site_name":"dbi Blog","article_published_time":"2015-04-07T04:57:00+00:00","og_image":[{"width":764,"height":823,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png","type":"image\/png"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"QlikSense \u2013 The easy way to create a QlikView report","datePublished":"2015-04-07T04:57:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/"},"wordCount":1111,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png","keywords":["Business Intelligence","QlikSense","QlikView","Reporting services"],"articleSection":["Enterprise content management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/","url":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/","name":"QlikSense \u2013 The easy way to create a QlikView report - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png","datePublished":"2015-04-07T04:57:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/BI-Gartner-201502.png","width":764,"height":823},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/qliksense-the-easy-way-to-create-a-qlikview-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"QlikSense \u2013 The easy way to create a QlikView report"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&amp;H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4483"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4483\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4484"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4483"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}