Reader small image

You're reading from  Qlik Sense Cookbook. - Second Edition

Product typeBook
Published inAug 2018
PublisherPackt
ISBN-139781788997058
Edition2nd Edition
Right arrow
Authors (3):
Pablo Labbe
Pablo Labbe
author image
Pablo Labbe

Pablo is a Business Intelligence Consultant with over 18 years of experience. In 2008 he was presented to Qlikview, the former product by Qlik and the seed for Qlik Sense. Since that year he was focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia delivering BI projects and training focusing on Qlik products and other technologies that embrace the Self-Service BI. He is an active member of the Qlik Community and other social media sites. You can follow him on Twitter - @pablolabbe and LinkedIn.
Read more about Pablo Labbe

Philip Hand
Philip Hand
author image
Philip Hand

Philip Hand is a Senior Business Intelligence consultant who has worked with QlikView in the BI space for over 7 years. Working with Qlik's top partner in the UK, he has implemented end-to-end solutions in a wide variety of enterprises and for large business customers. Philip has great experience and knowledge working across many sectors from the public sector, insurance, and financial services to large retailer and manufacturing businesses.
Read more about Philip Hand

Neeraj Kharpate
Neeraj Kharpate
author image
Neeraj Kharpate

Neeraj Kharpate works as a Senior Business Intelligence consultant at Capventis, a QlikView Elite Partner. Having started his career working as a technical support executive for an aviation ERP, Neeraj embarked on his journey with Qlikview in mid-2007. He is a certified Qlikview designer, developer, and trainer. Neeraj has been closely following the developments in Qlik Sense ever since it was launched in 2014 and is extremely excited about the future of this product. Neeraj has completed his Masters in Business Administration from the Norwich Business School, University of East Anglia. He also has a diploma in Management Consulting from the Chartered Management Institute, UK.
Read more about Neeraj Kharpate

View More author details
Right arrow

Effectively using the KPI object in Qlik Sense®


A visualization should provide the user with a clear and effective presentation of the data. Numbers have an impact and they contain a message. Key performance indicators demonstrate the importance of numbers in business and also communicate the health of the business to the audience.

Getting ready

We will make use of the application from the preceding recipe. The application has the following script loaded; it gives information on theSalesandTargetvalues for four countries:

LOAD * INLINE [
Country, Sales, Target
USA, 10000, 8500
UK, 7000, 9500
Germany, 5000, 4500
Japan, 6000, 6000
];

How to do it…

  1. Go to theApp overviewand create a new sheet.
  2. Name the sheet KPI and open it.
  3. Go to Edit mode by clicking on 
    .
  4. Drag the 
     object from the assets panel onto the sheet.
  5. Next, add the following measure:
(Sum(Sales)-Sum(Target))/Sum(Target)
  1. Name the label Sales vs Target.
  2. Once we add the measure, we can see a host of properties, such as number format, color, and so...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Qlik Sense Cookbook. - Second Edition
Published in: Aug 2018Publisher: PacktISBN-13: 9781788997058

Authors (3)

author image
Pablo Labbe

Pablo is a Business Intelligence Consultant with over 18 years of experience. In 2008 he was presented to Qlikview, the former product by Qlik and the seed for Qlik Sense. Since that year he was focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia delivering BI projects and training focusing on Qlik products and other technologies that embrace the Self-Service BI. He is an active member of the Qlik Community and other social media sites. You can follow him on Twitter - @pablolabbe and LinkedIn.
Read more about Pablo Labbe

author image
Philip Hand

Philip Hand is a Senior Business Intelligence consultant who has worked with QlikView in the BI space for over 7 years. Working with Qlik's top partner in the UK, he has implemented end-to-end solutions in a wide variety of enterprises and for large business customers. Philip has great experience and knowledge working across many sectors from the public sector, insurance, and financial services to large retailer and manufacturing businesses.
Read more about Philip Hand

author image
Neeraj Kharpate

Neeraj Kharpate works as a Senior Business Intelligence consultant at Capventis, a QlikView Elite Partner. Having started his career working as a technical support executive for an aviation ERP, Neeraj embarked on his journey with Qlikview in mid-2007. He is a certified Qlikview designer, developer, and trainer. Neeraj has been closely following the developments in Qlik Sense ever since it was launched in 2014 and is extremely excited about the future of this product. Neeraj has completed his Masters in Business Administration from the Norwich Business School, University of East Anglia. He also has a diploma in Management Consulting from the Chartered Management Institute, UK.
Read more about Neeraj Kharpate