What is the use of Button object or function in QlikView

This recipe explains what is the use of Button object or function in QlikView

Recipe Objective:-What is the use of Button object/function 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.

Access Avocado Machine Learning Project for Price Prediction

Step 4:-

Now from Main Sheet->Right click->New sheet object->Chart->Bar chart->Select Dimension as "Product Type" 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.

Step 5:-

Then click on Next->Next->Finish.The Bar chart will be then available in the Main sheet/QlikView Document->Go to the sheet->Right click on Bar chart->Properties->Layout tab->Show option->Select Conditional->Assign a variable from Expression tab->Here a variable 'BrokenWeeks' is assigned->click on Ok->Then Go to main sheet->Right click->New sheet object->Select Button option->General tab->Text window->Type as Show->Then go to Action tab->Action Type->External->Set variable->click on Variable option->select Brokenweeks variable from Expression tab->Paste->Ok->Now from the Button object Action tab->set Value as '1' ->Apply->Ok .

Step 6:-

Then Again go to main sheet->Right click->New sheet object->Select Button option->General tab->Text window->Type as Hide->Then go to Action tab->Action Type->External->Set variable->click on Variable option->select Brokenweeks variable from Expression tab->Paste->Ok->Now from the Button object Action tab->set Value as '0' ->Apply->Ok->In this way two button objects,that is 'Show' and 'Hide 'will be displayed 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

Census Income Data Set Project-Predict Adult Census Income
Use the Adult Income dataset to predict whether income exceeds 50K yr based oncensus data.

Credit Card Default Prediction using Machine learning techniques
In this data science project, you will predict borrowers chance of defaulting on credit loans by building a credit score prediction model.

MLOps Project to Build Search Relevancy Algorithm with SBERT
In this MLOps SBERT project you will learn to build and deploy an accurate and scalable search algorithm on AWS using SBERT and ANNOY to enhance search relevancy in news articles.

Build Regression Models in Python for House Price Prediction
In this Machine Learning Regression project, you will build and evaluate various regression models in Python for house price prediction.

Machine Learning Project to Forecast Rossmann Store Sales
In this machine learning project you will work on creating a robust prediction model of Rossmann's daily sales using store, promotion, and competitor data.

Hands-On Approach to Master PyTorch Tensors with Examples
In this deep learning project, you will learn how to perform various operations on the building block of PyTorch : Tensors.

Build a Collaborative Filtering Recommender System in Python
Use the Amazon Reviews/Ratings dataset of 2 Million records to build a recommender system using memory-based collaborative filtering in Python.

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.

Build an Image Segmentation Model using Amazon SageMaker
In this Machine Learning Project, you will learn to implement the UNet Architecture and build an Image Segmentation Model using Amazon SageMaker

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.