{"id":46108,"date":"2018-12-22T11:56:52","date_gmt":"2018-12-22T06:26:52","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=46108"},"modified":"2018-12-21T14:59:36","modified_gmt":"2018-12-21T09:29:36","slug":"kpi-in-qlik-sense","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/","title":{"rendered":"KPI in Qlik Sense – Properties, Advantages and Limitations"},"content":{"rendered":"

Earlier, we have discussed Qlik Sense Combo Chart<\/a><\/strong>. Today, we will see KPI in Qlik Sense. In this tutorial, we are going to learn about how to use KPIs as visualizations in Qlik Sense sheets. Also, we will work towards understanding the role of KPIs in a BI tool<\/a><\/strong> like Qlik Sense along and learning how to use KPI visualizations in Qlik Sense sheets.<\/span><\/p>\n

So, let’s start Qlik Sense KPI Tutorial.<\/p>\n

\"KPI<\/a>

KPI in Qlik Sense – Properties, Advantages and Limitations<\/p><\/div>\n

1. What is KPI<\/span>\u00a0in Qlik Sense?<\/span><\/h2>\n

KPI stands for <\/span>Key Performance Indicator <\/span><\/i>which are the measure values used as performance trackers. We use KPIs to indicate the current state of an enterprise functioning by displaying calculated values like average sales, maximum sales, minimum sales, total sales etc. You can apply conditional colors and symbols to make them more dynamic and indicative of the performance state they are showing. For instance, you can give a red color to a lower value, symbolize it with a downward arrow, or use green color for a higher value etc. You can also set a range and limit for the values. In Qlik Sense, you can add such KPIs on the sheet as distinct visualizations<\/a><\/strong> which we can handle and edit separately.\u00a0 \u00a0<\/span><\/p>\n

\"KPI<\/a>

What is KPI in Qlik Sense<\/p><\/div>\n

2. How to Create KPI Visualization in Qlik Sense?<\/span><\/h2>\n

In order to create a KPI visualization in Qlik Sense, follow the steps given below. <\/span><\/p>\n

Step 1<\/b>: Open the editor of the sheet of the application in which you want to create a KPI visualization. The editor is opened, from the edit option present on the toolbar.<\/span><\/p>\n

Step 2<\/b>: Select the option KPI (from the Assets Panel) and add it to the editing grid at the center by dragging and dropping. <\/span><\/p>\n

\"KPI<\/a>

Select KPI from Assert Panel<\/p><\/div>\n

Step 3<\/b>: Add a measure for the KPI. You add more measures from the properties panel later.\u00a0<\/span><\/p>\n

Recommended Reading – Qlik Sense Histogram Visualizations<\/a><\/strong><\/p>\n

\"KPI<\/a>

Adding Measure for the KPI<\/p><\/div>\n

Next, you can add an aggregation type to the values of the selected field\/measure.<\/span><\/p>\n

\"KPI<\/a>

Add Aggregation Type<\/p><\/div>\n

Step 4<\/b>: Once you are done with selecting and adjusting all the different aspects of it. The KPI will be displayed on the editor instantly. Click done to bring it on the sheet.<\/span><\/p>\n

\"KPI<\/a>

Displaying the KPI in Qlik Sense<\/p><\/div>\n

The KPI shown above shows two calculations, i.e. average cost and maximum product cost with relevant symbols aside them. <\/span><\/p>\n

3. Properties of Qlik Sense KPI<\/span><\/h2>\n

From the properties panel present at the right of the editor, you can manage different aspects of the KPI visualization and make it according to your requirement.<\/span><\/p>\n

You must read – Qlik Sense Text and Image Visualization<\/a><\/strong><\/p>\n

i. Data<\/span><\/h3>\n

From the data tab, you can add measures for first and second KPI. You can edit an expression, add a label, set the number formatting for the calculated values. You can add up to two measures only. <\/span><\/p>\n

\"KPI<\/a>

Add measures for the first and Second KPI<\/p><\/div>\n

ii. Add-ons<\/span><\/h3>\n

In this section, you can use the data handling option to apply certain display conditions on the data. The KPIs are only displayed if the applied condition holds true. <\/span><\/p>\n

\"KPI<\/a>

Using Data Handling Options for Add-ons<\/p><\/div>\n

iii. Appearance<\/span><\/h3>\n

The appearance section contains all the setting related to the appearance of the KPIs. <\/span><\/p>\n

The first section is the <\/span>General<\/span><\/i> section has options for showing or hiding titles or details. <\/span><\/p>\n

\"KPI<\/a>

Appearance – General Section<\/p><\/div>\n

The <\/span>Presentation<\/span><\/i> section in Qlik Sense<\/a><\/strong> KPI gives you options to adjust the alignment of the KPI information, font size. You can also link the KPI to other sheets in the app. \u00a0<\/span><\/p>\n

Let’s revise Box Plot in Qlik Sense Visualization<\/a><\/strong><\/p>\n

\"KPI<\/a>

Appearance – Presentation Section<\/p><\/div>\n

From the <\/span>Colors<\/span><\/i> section, you set the coloring criteria for the KPIs. You can add a color condition and associate a symbol to it. Also, you can add value limits in KPIs which are shown in a certain color up until that limit and then changes the color when gone beyond the limit.\u00a0<\/span><\/p>\n

\"KPI<\/a>

Appearance – Color Section<\/p><\/div>\n

\"KPI<\/a>

Adding Color Condition<\/p><\/div>\n

Do you know about Qlik Sense Gauge Chart<\/a><\/strong><\/p>\n

4. Advantages and limitations of using KPIs<\/span><\/h2>\n

One major limitation of the KPIs is that you can only have a generalized result of the performance through values and a limited set of symbols. If you want a more clear and relative representation of performance indicators, then you can go for using gauge charts. However, an evident advantage is that KPIs provide a quick and to the point representation of the performance results using which you can reach to conclusions in your analysis easily as to how the enterprise has performed over a certain period.<\/span><\/p>\n

So, this was all in KPI in Qlik Sense.<\/p>\n

5. Summary<\/span><\/h2>\n

We hope through this tutorial, you have learned how to create and use KPIs for an appropriate purpose in your Qlik Sense app. If you have any queries related to the KPI visualization, leave it in the comment box below.<\/span><\/p>\n

You must check – Qlik Sense Capabilities<\/a><\/strong>

Earlier, we have discussed Qlik Sense Combo Chart. Today, we will see KPI in Qlik Sense. In this tutorial, we are going to learn about how to use KPIs as visualizations in Qlik Sense...<\/p>\n","protected":false},"author":6,"featured_media":46132,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[18031,18030,18028,18033,18032,18027,18029],"class_list":["post-46108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-advantages-of-kpi","tag-how-to-create-kpi-in-qlik-sense","tag-kpi-in-qlik-sense","tag-kpi-properties","tag-limitations-of-kpi","tag-qlik-sense-kpi","tag-what-is-kpi-in-qlik-sense"],"yoast_head":"\nKPI in Qlik Sense - Properties, Advantages and Limitations - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn KPI in Qlik Sense - Meaning, properties, advantages and disadvantages of KPI, learn how to create Qlik Sense KPI in 4 simple steps\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KPI in Qlik Sense - Properties, Advantages and Limitations - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn KPI in Qlik Sense - Meaning, properties, advantages and disadvantages of KPI, learn how to create Qlik Sense KPI in 4 simple steps\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-22T06:26:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KPI in Qlik Sense - Properties, Advantages and Limitations - DataFlair","description":"Learn KPI in Qlik Sense - Meaning, properties, advantages and disadvantages of KPI, learn how to create Qlik Sense KPI in 4 simple steps","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:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/","og_locale":"en_US","og_type":"article","og_title":"KPI in Qlik Sense - Properties, Advantages and Limitations - DataFlair","og_description":"Learn KPI in Qlik Sense - Meaning, properties, advantages and disadvantages of KPI, learn how to create Qlik Sense KPI in 4 simple steps","og_url":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-12-22T06:26:52+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"KPI in Qlik Sense – Properties, Advantages and Limitations","datePublished":"2018-12-22T06:26:52+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/"},"wordCount":918,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg","keywords":["Advantages of KPI","How to create KPI in Qlik Sense","KPI in Qlik Sense","KPI Properties","Limitations of KPI","Qlik Sense KPI","What is KPI in Qlik Sense"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/","url":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/","name":"KPI in Qlik Sense - Properties, Advantages and Limitations - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg","datePublished":"2018-12-22T06:26:52+00:00","description":"Learn KPI in Qlik Sense - Meaning, properties, advantages and disadvantages of KPI, learn how to create Qlik Sense KPI in 4 simple steps","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/KPI-in-Qlik-Sense-01.jpg","width":1200,"height":628,"caption":"KPI in Qlik Sense - Properties, Advantages and Limitations"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"KPI in Qlik Sense – Properties, Advantages and Limitations"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=46108"}],"version-history":[{"count":1,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46108\/revisions"}],"predecessor-version":[{"id":46133,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46108\/revisions\/46133"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/46132"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=46108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=46108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=46108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}