How to Change the Tab color and Background of a sheet in QlikView

This recipe helps you Change the Tab color and Background of a sheet in QlikView

Recipe Objective:-How to Change the Tab color and Background of a sheet 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 "Sales 2017-Copy" and Sheet1 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->Select Fields->General tab->Tab setting->select Custom colors->select color of choice->click on Apply and Ok->The tab color will be changed in the Main sheet. If we want to change text color, it can also be done from the Tab text color option.

Step 5:-

Now click on Background->select Sheet settings->click on the Color checkbox->Select color of choice->click on Apply and Ok. The changed tab color and background will be available in the Main sheet/QlikView Document.

What Users are saying..

profile image

Anand Kumpatla

Sr Data Scientist @ Doubleslash Software Solutions Pvt Ltd
linkedin profile url

ProjectPro is a unique platform and helps many people in the industry to solve real-life problems with a step-by-step walkthrough of projects. A platform with some fantastic resources to gain... Read More

Relevant Projects

Customer Churn Prediction Analysis using Ensemble Techniques
In this machine learning churn project, we implement a churn prediction model in python using ensemble techniques.

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.

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.

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.

End-to-End Snowflake Healthcare Analytics Project on AWS-1
In this Snowflake Healthcare Analytics Project, you will leverage Snowflake on AWS to predict patient length of stay (LOS) in hospitals. The prediction of LOS can help in efficient resource allocation, lower the risk of staff/visitor infections, and improve overall hospital functioning.

NLP Project on LDA Topic Modelling Python using RACE Dataset
Use the RACE dataset to extract a dominant topic from each document and perform LDA topic modeling in python.

Build Multi Class Text Classification Models with RNN and LSTM
In this Deep Learning Project, you will use the customer complaints data about consumer financial products to build multi-class text classification models using RNN and LSTM.

ML Model Deployment on AWS for Customer Churn Prediction
MLOps Project-Deploy Machine Learning Model to Production Python on AWS for Customer Churn Prediction

Linear Regression Model Project in Python for Beginners Part 1
Machine Learning Linear Regression Project in Python to build a simple linear regression model and master the fundamentals of regression for beginners.

Classification Projects on Machine Learning for Beginners - 1
Classification ML Project for Beginners - A Hands-On Approach to Implementing Different Types of Classification Algorithms in Machine Learning for Predictive Modelling