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

Creating treemaps


Treemaps (previously called block charts in QlikView) are a good way to show how different parts combine to form a whole. To add more depth to the visualization, you can easily highlight areas of importance by adding color coding.

Getting ready

For this recipe, we will make use of inline data loading, which provides product sales information. Load the following code into the data load editor:

LOAD * INLINE [
 Product Line, Product Group, Product Sub Group, Year, Sales, 
 Cost
 Drink, Beverages, Juice, 2015, 12000, 6000
 Drink, Beverages, Juice, 2014, 16000, 7000
 Drink, Beverages, Soda, 2015, 42000, 26000
 Drink, Beverages, Soda, 2014, 68000, 57000
 Drink, Beverages, Water, 2015, 18000, 8000
 Drink, Beverages, Water, 2014, 10000, 6000
 Drink, Dairy, Milk, 2015, 25000, 22000
 Drink, Dairy, Milk, 2014, 22000, 20000
 Food, Dairy, Cheese, 2015, 22000, 8000
 Food, Dairy, Cheese, 2014, 31000, 30000
 Food, Produce, Nuts, 2015, 50000, 30000
 Food, Produce, Nuts, 2014, 46000, 26000...
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