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.
For this QlikView Mekko Chart demo, we are loading the above specified excel sheet into the QlikView.
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
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.
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.
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.
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.
Click the OK button to close the edit expression window and then click the Next button.
Sort page is useful to specify the sorting order for the dimensions. In this example, we sort the Country in Ascending order.
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.
The presentation page changes the Presentation of a Mekko chart. For example, changing the Data Point, enable axis scrolling, etc.
Axes page is useful to change the Axis Color, Scale, and Scale lengths (Minimum, Maximum Value, etc)
The QlikView Mekko Chart Colors page is useful to change the Color pattern. Try to mix different options
Formatting the Expression value: As we all know that the Sum of Sales Amount is money, so we are selecting the money.
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
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).
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.
Now, see our newly created Mekko Chart in QlikView.
Hover over the mouse on the Mekko chart display the Country Name, Occupation, and Sales amount (Data label).