How to create a dashboard in QlikView

This recipe helps you create a dashboard in QlikView

Recipe Objective:-How to create a dashboard in QlikView?

Step 1:-

Open QlikView 12 software. Here a Start page will, by default available; if we do not want we can also untick the check box given below and avoid the start page while launching QlikView every time.

Step 2:-

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

Step 3:-

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

Step 4:-

Now from Main Sheet->Right click->New sheet object->Chart->Give Window title as"Sales chart"->select Bar 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 Bar Chart will then be available in the Main sheet/QlikView Document.

Step 6:-

Now from Main Sheet->Right click->New sheet object->List box->Select the Field name as "Category"->Select option "Show as TreeView"->Then click on Ok->The List box will be available in the Main sheet/QlikView Document.

Step 7:-

Now from Main Sheet->Right click->New sheet object->Table box->click on Add All->Apply->Ok->Table box will be then available in the Main sheet/QlikView Document.

Step 8:-

Now follow the same procedure as given in step 4 and create a "Gauge chart", only select the "Expression" as Profit (Sum of Profit)->Then apply it and click on ok.

Step 9:-

The dashboard containing Bar chart, List box, Table box, and Gauge chart will then be available in the Main sheet/QlikView Document.

What Users are saying..

profile image

Ed Godalle

Director Data Analytics at EY / EY Tech
linkedin profile url

I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More

Relevant Projects

NLP and Deep Learning For Fake News Classification in Python
In this project you will use Python to implement various machine learning methods( RNN, LSTM, GRU) for fake news classification.

Build a Music Recommendation Algorithm using KKBox's Dataset
Music Recommendation Project using Machine Learning - Use the KKBox dataset to predict the chances of a user listening to a song again after their very first noticeable listening event.

Credit Card Fraud Detection as a Classification Problem
In this data science project, we will predict the credit card fraud in the transactional dataset using some of the predictive models.

Build Deep Autoencoders Model for Anomaly Detection in Python
In this deep learning project , you will build and deploy a deep autoencoders model using Flask.

Create Your First Chatbot with RASA NLU Model and Python
Learn the basic aspects of chatbot development and open source conversational AI RASA to create a simple AI powered chatbot on your own.

Learn to Build an End-to-End Machine Learning Pipeline - Part 1
In this Machine Learning Project, you will learn how to build an end-to-end machine learning pipeline for predicting truck delays, addressing a major challenge in the logistics industry.

Hands-On Approach to Regression Discontinuity Design Python
In this machine learning project, you will learn to implement Regression Discontinuity Design Example in Python to determine the effect of age on Mortality Rate in Python.

Deploy Transformer-BART Model on Paperspace Cloud
In this MLOps Project you will learn how to deploy a Tranaformer BART Model for Abstractive Text Summarization on Paperspace Private Cloud

Detectron2 Object Detection and Segmentation Example Python
Object Detection using Detectron2 - Build a Dectectron2 model to detect the zones and inhibitions in antibiogram images.

End-to-End Snowflake Healthcare Analytics Project on AWS-2
In this AWS Snowflake project, you will build an end to end retraining pipeline by checking Data and Model Drift and learn how to redeploy the model if needed