How to add text or number on an axis in the chart by using Qlikview

This recipe helps you add text or number on an axis in the chart by using Qlikview

Recipe Objective: How to add text or numbers on an axis in the chart by using 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 "Sample-sales-data-excel" 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 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. Now right-click on bar chart->Properties->Expressions tab->From the display options->Select Text on-axis. Then the text or number will be the available axis of the bar chart.

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

Demand prediction of driver availability using multistep time series analysis
In this supervised learning machine learning project, you will predict the availability of a driver in a specific area by using multi step time series analysis.

Recommender System Machine Learning Project for Beginners-4
Collaborative Filtering Recommender System Project - Comparison of different model based and memory based methods to build recommendation system using collaborative filtering.

Customer Market Basket Analysis using Apriori and Fpgrowth algorithms
In this data science project, you will learn how to perform market basket analysis with the application of Apriori and FP growth algorithms based on the concept of association rule learning.

Skip Gram Model Python Implementation for Word Embeddings
Skip-Gram Model word2vec Example -Learn how to implement the skip gram algorithm in NLP for word embeddings on a set of documents.

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..

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.

Recommender System Machine Learning Project for Beginners-3
Content Based Recommender System Project - Building a Content-Based Product Recommender App with Streamlit

Predictive Analytics Project for Working Capital Optimization
In this Predictive Analytics Project, you will build a model to accurately forecast the timing of customer and supplier payments for optimizing working capital.

Build a Speech-Text Transcriptor with Nvidia Quartznet Model
In this Deep Learning Project, you will leverage transfer learning from Nvidia QuartzNet pre-trained models to develop a speech-to-text transcriptor.

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