Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
Jennell_McIntire
Employee
Employee

Check out the new mekko chart in the November 2019 release.

With the November 2019 release came a new chart for Qlik Sense - the mekko chart. The mekko chart allows users to compare a measure by group as well as by category within a group. The mekko chart takes two dimensions and one measure and utilizes height and width to show how values compare across dimensions.

 

Let’s look at an example. In the chart below, quarter is the first dimension, region is the second dimension and the measure is revenue. The quarters are listed across the top along with their normalized percentage value for revenue which is also visible via the width of each quarter (bar). So, you can see that Q1 is the widest bar because it had the largest revenue while Q3 is the narrowest and had the least amount of revenue. The height of each region in a quarter represents the normalized percentage value for revenue for that region within that quarter. So, if looking at Q1, the Americas had the most revenue while Africa had the least.

 

chart.png

 

The design of the chart makes it easy for the user to compare revenue by quarter, revenue by region within each quarter, as well as revenue by region across quarters. A few things to note are the mekko chart cannot show negative values and does not work well if there are many dimension values. You should also avoid using the mekko chart if you want to mix absolute and relative values. The mekko chart is easy to create and easy to read. You can learn more about the mekko chart and other new features of the November 2019 release in the Qlik Product Innovation Blog, the What’s New – Qlik Product Release Video and the What’s New app.

 

Thanks,

Jennell

2 Comments
paulcalvet
Partner - Specialist
Partner - Specialist

Hello,

This new chart is a good news.

I hope that you will make some improvements to the other charts. 

For example :

- Vertical view for combo chart

- More than 1000 dots on scatter chart

- Linear regression for scatter chart

- Add image in table

- Add sparkline in table

- The possibilitie to chose a color for a measure which is not a master item

Thanks

 

2,369 Views
anderseriksson
Partner - Specialist
Partner - Specialist

"The design of the chart makes it easy for the user to compare ... revenue by region across quarters."

Not quite, looking at Americas, it looks like Q3 is an increase from Q2 since the bar is higher but that' not true.
Same with Europe, user has to compare area and that is not as easy as comparing hight.
A stacked bar chart would do a better job in this case.

Second te request for improvements on other charts, in particular colours.

2,209 Views