Breaking down data by category helps with many kinds of analysis. In this video, learn how to create a treemap chart, which uses size and color to show the relative values of data categories and subcategories within a collection.
- [Instructor] Breaking down data by category helps with many kinds of analysis. In this movie, I will show you how to create a treemap chart, which uses size and color to show the relative values of data categories and sub-categories within a collection. I have created an app and opened a blank sheet for editing. The data that I use comes from the All Details workbook, which you can find in the Exercise Files folder. I'll go over to the assets panel and click Charts, and then on my screen I need to scroll down, and I will drag a Treemap object onto the body of the sheet and I'll let it take up the entire sheet.
Now I can add a dimension, and I will use category, or in this case, ProductCategory. So I'll click Add dimension, and I will scroll down, and the field list that appears, using my scroll wheel, and click ProductCategory. Now I can add a measure, and you'll see how that will affect the different product categories when I get into it. So I'll click Add measure, and for this I will use the sum of order total, basically the value of all the orders for each of the product categories.
So I will scroll down again, and click Order Total, and use Sum. And there you see that grid-tie inverters account for most of the sales, followed by batteries, wind harvesters, solar panels, and my other two at the bottom, landscape lighting and light bulbs. So that's interesting, but let's say that I want to break it down even further by year and by quarter. For that I can add a second dimension, so I'll go over to the properties panel, and under Data, which for me was already displayed, click Add, under Rectangle, and I'll scroll down under Date of Purchase to YearQuarter, which is a built-in aggregation level.
I'll click that, and you can see that the data changes. I still have grid-tie inverters as the largest, but now you can see the sales as they are broken down by segment. And each rectangle represents the relative magnitude of sales for each quarter. You could also, if you wanted, change the order of the fields, to change the emphasis of your treemap. So I currently have ProductCategory as the group, and the Date of Purchase by year and quarter, as the rectangle.
If I drag Date of Purchase above ProductCategory, then you see how it changes. Most of the orders, which again are driven by grid-tie inverters, because they're the most expensive items, appear in quarter two of 2018, and then 2018 quarter three, 2017 quarter three, 2017 quarter one, and so on. Treemaps are wonderful for determining the relative contribution of elements to a data set. While they don't show you individual values, you can get an idea of how values compare to each other.
- Navigating the Qlik Sense user interface
- Managing data sources and tables
- Creating an app from a data source
- Managing Qlik Sense sheets
- Exporting Qlik Sense data to Excel
- Creating bar, line, pie, and scatter plot charts
- Creating charts, text, and images for dashboards
- Creating and manipulating PivotTables
- Sorting and filtering chart and table data