How to change the chart type in QlikView

This recipe helps you change the chart type in QlikView

Recipe Objective: How to change the chart type 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.

Step 3:

On the bottom New Document option is available. By clicking on the New Document option, a Wizard will get opened.

Learn How to Build a Simple Chatbot from Scratch in Python (using NLTK)

Step 4:

Now Select Data Source-> Browse->Select file from the folder; here, an excel file named "Office City Sales" is selected->then click on Next step. Now under Data Presentation->select "Use column headers for data file," then click on the Next step option and Save the file at a location/folder with the name of choice; here, the file name "qlik10" is used. Then again, click on the Next step option.

Step 5:

Now under the Chart type tab, Select the Bar chart->click on Next step option->Populate Chart->Select Dimension as "Territory"->under Expression tab select->Calculate sum of->Office Sales, then click on Next step option.

Step 6:

Now under the Selections tab->Select Listboxes->Create.The Bar Chart with Listboxes will be available in the Main sheet/QlikView Document.

Step 7:

Now Right-click on bar chart->Go to Properties->New sheet object->Chart->Under the General tab->Fast type change->select Line chart and Pie chart->The Bar chart will have an option of "Fast change"->Click on Fast change->The Bar chart will get changed to Line chart and Pie chart. Thus the result will be available in the Main sheet/QlikView Document.

What Users are saying..

profile image

Savvy Sahai

Data Science Intern, Capgemini
linkedin profile url

As a student looking to break into the field of data engineering and data science, one can get really confused as to which path to take. Very few ways to do it are Google, YouTube, etc. I was one of... Read More

Relevant Projects

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.

MLOps Project to Deploy Resume Parser Model on Paperspace
In this MLOps project, you will learn how to deploy a Resume Parser Streamlit Application on Paperspace Private Cloud.

A/B Testing Approach for Comparing Performance of ML Models
The objective of this project is to compare the performance of BERT and DistilBERT models for building an efficient Question and Answering system. Using A/B testing approach, we explore the effectiveness and efficiency of both models and determine which one is better suited for Q&A tasks.

PyTorch Project to Build a GAN Model on MNIST Dataset
In this deep learning project, you will learn how to build a GAN Model on MNIST Dataset for generating new images of handwritten digits.

Deep Learning Project for Time Series Forecasting in Python
Deep Learning for Time Series Forecasting in Python -A Hands-On Approach to Build Deep Learning Models (MLP, CNN, LSTM, and a Hybrid Model CNN-LSTM) on Time Series 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.

Linear Regression Model Project in Python for Beginners Part 2
Machine Learning Linear Regression Project for Beginners in Python to Build a Multiple Linear Regression Model on Soccer Player Dataset.

Stock Price Prediction Project using LSTM and RNN
Learn how to predict stock prices using RNN and LSTM models. Understand deep learning concepts and apply them to real-world financial data for accurate forecasting.

Word2Vec and FastText Word Embedding with Gensim in Python
In this NLP Project, you will learn how to use the popular topic modelling library Gensim for implementing two state-of-the-art word embedding methods Word2Vec and FastText models.

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