How to use Auto minimize function for charts in QlikView

This recipe helps you use Auto minimize function for charts in QlikView

Recipe Objective:-How to use the Auto minimize function for charts 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 "Coffee Chain Sales" is being loaded and Select "Coffee Chain Sales" table->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->Bar chart->Select Dimension as "Product" also select "Coffee chain sales" table->under Expression tab->Select "Sum" Aggregation->Select Table as "Coffee chain sales" table->Select Field as "Coffee Sales"->Click on Paste->Ok->If we want use accumulation, we can use it->then click on Next->Next->Next->Finish.The Bar chart will be then available in the Main sheet/QlikView Document.

Step 5:-

In the similar way from Main Sheet->Right click->New sheet object->Chart->Pie chart->Select Dimension as "Product" also select "Coffee chain sales" table->under Expression tab->Select "Sum" Aggregation->Select Table as "Coffee chain sales" table->Select Field as "Coffee Sales"->Click on Paste->Ok->then click on Next->Next->Next->Finish.The Pie chart will be then available in the Main sheet/QlikView Document.

Step 6:-

Now go to Bar chart in the Main sheet->Right click->Properties->Caption tab->Click on Auto minimize option check box->then click on Apply and Ok->Similarly Right-click on Pie chart->Properties->Caption tab->Click on Auto minimize option check box->then click on Apply and Ok.Therefore if One chart is opened, then the other charts will get auto minimized and available in the Main sheet/QlikView document; for simplicity of the sheet, we can use the auto minimize option for charts.

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

Build a Logistic Regression Model in Python from Scratch
Regression project to implement logistic regression in python from scratch on streaming app data.

House Price Prediction Project using Machine Learning in Python
Use the Zillow Zestimate Dataset to build a machine learning model for house price prediction.

Topic modelling using Kmeans clustering to group customer reviews
In this Kmeans clustering machine learning project, you will perform topic modelling in order to group customer reviews based on recurring patterns.

Loan Eligibility Prediction in Python using H2O.ai
In this loan prediction project you will build predictive models in Python using H2O.ai to predict if an applicant is able to repay the loan or not.

Build a Face Recognition System in Python using FaceNet
In this deep learning project, you will build your own face recognition system in Python using OpenCV and FaceNet by extracting features from an image of a person's face.

Learn Hyperparameter Tuning for Neural Networks with PyTorch
In this Deep Learning Project, you will learn how to optimally tune the hyperparameters (learning rate, epochs, dropout, early stopping) of a neural network model in PyTorch to improve model performance.

Build a Multi Touch Attribution Machine Learning Model in Python
Identifying the ROI on marketing campaigns is an essential KPI for any business. In this ML project, you will learn to build a Multi Touch Attribution Model in Python to identify the ROI of various marketing efforts and their impact on conversions or sales..

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.

Learn to Build a Neural network from Scratch using NumPy
In this deep learning project, you will learn to build a neural network from scratch using NumPy

Learn to Build Generative Models Using PyTorch Autoencoders
In this deep learning project, you will learn how to build a Generative Model using Autoencoders in PyTorch