How to create a Grid chart in QlikView

This recipe helps you create a Grid chart in QlikView

Recipe Objective: How to create a Grid 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.

Build Expedia Hotel Recommendation System using Machine Learning

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 "Sales 2017-Copy" is loaded. Click on Reload button from the menu bar and save the file, So that data will also get loaded in the sheet.

Step 4:

Now from Main Sheet->Right-click->New sheet object-> Chart->select Grid chart-> Next-> Select Dimension as "Area" and "Product Id", also select "Sheet1" table->under Expression tab-> Select "Sum" Aggregation-> Select Table as "Sheet1" table-> Select Field as "Sales Done"->Click on Paste->Ok. Multicolor option will be by default selected for the Grid chart.

Step 5:

Then click on Next->Next->Finish. The Grid Chart will then be 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

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.

End-to-End Speech Emotion Recognition Project using ANN
Speech Emotion Recognition using RAVDESS Audio Dataset - Build an Artificial Neural Network Model to Classify Audio Data into various Emotions like Sad, Happy, Angry, and Neutral

Build Portfolio Optimization Machine Learning Models in R
Machine Learning Project for Financial Risk Modelling and Portfolio Optimization with R- Build a machine learning model in R to develop a strategy for building a portfolio for maximized returns.

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.

Machine Learning project for Retail Price Optimization
In this machine learning pricing project, we implement a retail price optimization algorithm using regression trees. This is one of the first steps to building a dynamic pricing model.

Loan Eligibility Prediction using Gradient Boosting Classifier
This data science in python project predicts if a loan should be given to an applicant or not. We predict if the customer is eligible for loan based on several factors like credit score and past history.

Customer Churn Prediction Analysis using Ensemble Techniques
In this machine learning churn project, we implement a churn prediction model in python using ensemble techniques.

End-to-End ML Model Monitoring using Airflow and Docker
In this MLOps Project, you will learn to build an end to end pipeline to monitor any changes in the predictive power of model or degradation of data.

Medical Image Segmentation Deep Learning Project
In this deep learning project, you will learn to implement Unet++ models for medical image segmentation to detect and classify colorectal polyps.

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.