Mekko Chart in QlikView

Mekko Chart in QlikView is very useful for displaying up to three levels of data. This article shows how to Create a Mekko Chart in QlikView with an example. For this QlikView Mekko Chart demo, we will use the data in the following Excel table.

excel Source 1

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

Load Excel File 2

Create a Mekko Chart in QlikView

In this QlikView example, we create a Mekko chart for all the Countries, occupations, and corresponding sales amounts. 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

Add New Sheet Object from Layout 3

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

New Sheet Object Option 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 to our demo and then selected the type. Please refer to the 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 for this session. For this example, we are adding the Country and Occupation dimensions to the used dimension section.

Add available fields to used dimensions 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 Field as Sales Amount, Aggregation as Sum, and click the Paste button.

edit and Add expression 7

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

Mekko Chart in QlikView 8

A 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 it. For example, changing the Data Point, enabling axis scrolling, etc.

Mekko Chart in QlikView 11

The 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 for changing 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 the 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 this, and apply the custom theme by clicking an. Apply the Theme button. From the screenshot below, see that we changed the shadow intensity to Intense, and the 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

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

Mekko Chart in QlikView 19