Mekko Chart in QlikView

Mekko Chart in QlikView is very useful to display up to three levels of data. In this article, we show how to Create a Mekko Chart in QlikView with an example. For this QlikView Mekko Chart demo, we are going to use the data present in the following Excel table.

Mekko Chart in QlikView 1

For this QlikView Mekko Chart demo, we are loading the above specified excel sheet into the QlikView.

Mekko Chart in QlikView 2

Create a Mekko Chart in QlikView

In this QlikView example, we create a Mekko chart for all the Countries, Occupation, and corresponding sales amount. To do this, we are going to use the Country, occupation Columns as the dimension data, and the Sales Amount expression.

We can create a QlikView Mekko chart in multiple ways. First Approach: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option

Mekko Chart in QlikView 3

Another approach is to Right-click on the Report area opens the Context menu. Please select the New Sheet Object from the context menu, and then select the Charts.. option.

Mekko Chart in QlikView 4

Either way, it opens a new window to create a Mekko Chart in QlikView. From the below screenshot, see we assigned a new name called Example for Mekko Chart to our chart, and then selected the chart type as the Mekko Chart. Please refer to Import data from Excel to QlikView article to import the excel tables in QlikView.

Mekko Chart in QlikView 5

Please select the Dimension columns to use in the Mekko chart. For this example, we are adding the Country and Occupation dimensions to the used dimension section.

Mekko Chart in QlikView 6

Clicking the Next button opens the Expression page, and on top of that, a popup Edit Expression window opened. Use this window to write the custom expression.

From the screenshot below, we are writing an expression under the Expression OK section. If you do not know to write an expression, Please select the Filed as Sales Amount, Aggregation as Sum, and click the Paste button.

Mekko Chart in QlikView 7

Click the OK button to close the edit expression window and then click the Next button.

Mekko Chart in QlikView 8

Sort page is useful to specify the sorting order for the dimensions. In this example, we sort the Country in Ascending order.

Mekko Chart in QlikView 9

The next QlikView Mekko chart page is to change the look and style. Here, we changed the Plot Area Background Style to Shadow and Plot Color Style to Light Gradient.

Mekko Chart in QlikView 10

The presentation page changes the Presentation of a Mekko chart. For example, changing the Data Point, enable axis scrolling, etc.

Mekko Chart in QlikView 11

Axes page is useful to change the Axis Color, Scale, and Scale lengths (Minimum, Maximum Value, etc)

Mekko Chart in QlikView 12

The QlikView Mekko Chart Colors page is useful to change the Color pattern. Try to mix different options

Mekko Chart in QlikView 13

Formatting the Expression value: As we all know that the Sum of Sales Amount is money, so we are selecting the money.

Mekko Chart in QlikView 14

The font page changes the Font family, style, and font size as per requirements. Here, we changed the Font = Sitka Small and Font size to 11

Mekko Chart in QlikView 15

The layout page provides the shadow effects to the Mekko chart, and apply the custom theme by clicking an Apply Theme button. From the screenshot below, see that we changed the shadow intensity to Intense, and Border width to 3 (extra thickness to the border).

Mekko Chart in QlikView 16

Use this Caption page to style the QlikView Mekko Chart Caption. Here, one can change the Mekko Chart background, position, color, and so on. From the screenshot below, see that we changed the Active Text color and the background. Once done, click the Finish button.

Mekko Chart in QlikView 17

Now, see our newly created Mekko Chart in QlikView.

Mekko Chart in QlikView 18

Hover over the mouse on the Mekko chart display the Country Name, Occupation, and Sales amount (Data label).

Mekko Chart in QlikView 19