How to create a Mekko chart in QlikView

This recipe helps you create a Mekko chart in QlikView

Recipe Objective: How to create a Mekko chart in QlikView?

Step 1:

Open QlikView 12 software. By default, the start page will open. To avoid the start page while launching QlikView, untick the check box at the bottom of the window.

Step 2:

On the start page, we can see the Examples, Recent, and Favorites tab. The saved files will appear under the Recent tab.

Market Basket Analysis Project in Python with Real World Example

Step 3:

When the QlikView 12 Software gets Open, A blank window appears. Go to menu bar-> File menu-> New-> The Main sheet appears. Again go to menu bar-> File menu-> Edit script, or we can also type Ctrl+E->Go to Table Files->Load the data source. Here, an excel file named "Sample-sales-data-excel" is loaded. Now click on Reload button from the menu bar so that that data will get loaded in the sheet.

Step 4:

Now from Main Sheet->Right click->New sheet object->Chart->select Mekko chart->click on Next->Select Dimension as "Region" and also select "Orders" table->under Expression tab->Select "Sum" Aggregation->Select Table as "Orders"table->Select Field as "Sales"->Click on Paste->Ok.

Step 5:-

Then click on Next->Next->Finish.The Mekko Chart will be then available in the Main sheet/QlikView Document

What Users are saying..

profile image

Ameeruddin Mohammed

ETL (Abintio) developer at IBM
linkedin profile url

I come from a background in Marketing and Analytics and when I developed an interest in Machine Learning algorithms, I did multiple in-class courses from reputed institutions though I got good... Read More

Relevant Projects

FEAST Feature Store Example for Scaling Machine Learning
FEAST Feature Store Example- Learn to use FEAST Feature Store to manage, store, and discover features for customer churn prediction machine learning project.

NLP Project to Build a Resume Parser in Python using Spacy
Use the popular Spacy NLP python library for OCR and text classification to build a Resume Parser in Python.

Build Customer Propensity to Purchase Model in Python
In this machine learning project, you will learn to build a machine learning model to estimate customer propensity to purchase.

Build a Multi ClassText Classification Model using Naive Bayes
Implement the Naive Bayes Algorithm to build a multi class text classification model in Python.

Loan Default Prediction Project using Explainable AI ML Models
Loan Default Prediction Project that employs sophisticated machine learning models, such as XGBoost and Random Forest and delves deep into the realm of Explainable AI, ensuring every prediction is transparent and understandable.

Learn How to Build a Linear Regression Model in PyTorch
In this Machine Learning Project, you will learn how to build a simple linear regression model in PyTorch to predict the number of days subscribed.

AWS MLOps Project to Deploy a Classification Model [Banking]
In this AWS MLOps project, you will learn how to deploy a classification model using Flask on AWS.

Expedia Hotel Recommendations Data Science Project
In this data science project, you will contextualize customer data and predict the likelihood a customer will stay at 100 different hotel groups.

Predict Churn for a Telecom company using Logistic Regression
Machine Learning Project in R- Predict the customer churn of telecom sector and find out the key drivers that lead to churn. Learn how the logistic regression model using R can be used to identify the customer churn in telecom dataset.

Natural language processing Chatbot application using NLTK for text classification
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.