How to show the Equation on a chart in QlikView

This recipe helps you show the Equation on a chart in QlikView

Recipe Objective:-How to show the Equation on a chart 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->then click on Next->Next->Next->Finish.The Bar chart will be then available in the Main sheet/QlikView Document.

Step 5:-

Now go to Bar chart in the Main sheet->Right click->Properties->Expression tab->Go to Trendlines option->Average Trendline->Click on show equation check box->Now click on Apply and Ok->Therefore different parameters can be selected, and their equation can be shown on the chart.

Step 6:-

Therefore in this way, the Bar chart with an equation will be available in the Main sheet/QlikView document.

What Users are saying..

profile image

Abhinav Agarwal

Graduate Student at Northwestern University
linkedin profile url

I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More

Relevant Projects

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

Digit Recognition using CNN for MNIST Dataset in Python
In this deep learning project, you will build a convolutional neural network using MNIST dataset for handwritten digit recognition.

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

Image Segmentation using Mask R-CNN with Tensorflow
In this Deep Learning Project on Image Segmentation Python, you will learn how to implement the Mask R-CNN model for early fire detection.

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.

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.

MLOps using Azure Devops to Deploy a Classification Model
In this MLOps Azure project, you will learn how to deploy a classification machine learning model to predict the customer's license status on Azure through scalable CI/CD ML pipelines.

OpenCV Project to Master Advanced Computer Vision Concepts
In this OpenCV project, you will learn to implement advanced computer vision concepts and algorithms in OpenCV library using Python.

AWS MLOps Project to Deploy Multiple Linear Regression Model
Build and Deploy a Multiple Linear Regression Model in Python on AWS

Build a Graph Based Recommendation System in Python-Part 2
In this Graph Based Recommender System Project, you will build a recommender system project for eCommerce platforms and learn to use FAISS for efficient similarity search.