What is the use of Input box object or function in QlikView

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

Recipe Objective:-What is the use of Input box 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.

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->Dimension limits tab->click on check box of 'Restrict which values are displayed using first expression'->click on Show only option->Select largest->Assign a variable from Expression tab->Here a variable named as 'Variable1' is assigned->click on Ok.Go to Main sheet->Right click->New sheet object->Input box->General tab->Title 'Bar chart levels'->Then Go to Avaliable Variables->click on Variable1->click on Add->If we want we can give label also, here 'levels' label is provided->then click on Ok.

Step 6:-

Then Again, go to the main sheet->The Input box object named 'Bar chart levels' will be displayed in the Main sheet/QlikView Document. We can change the levels according to requirements and press enter to see 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

Build Deep Autoencoders Model for Anomaly Detection in Python
In this deep learning project , you will build and deploy a deep autoencoders model using Flask.

Personalized Medicine: Redefining Cancer Treatment
In this Personalized Medicine Machine Learning Project you will learn to classify genetic mutations on the basis of medical literature into 9 classes.

Natural language processing Chatbot application using NLTK for text classification
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.

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.

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.

Build a Customer Churn Prediction Model using Decision Trees
Develop a customer churn prediction model using decision tree machine learning algorithms and data science on streaming service data.

Time Series Project to Build a Multiple Linear Regression Model
Learn to build a Multiple linear regression model in Python on Time Series Data

MLOps Project for a Mask R-CNN on GCP using uWSGI Flask
MLOps on GCP - Solved end-to-end MLOps Project to deploy a Mask RCNN Model for Image Segmentation as a Web Application using uWSGI Flask, Docker, and TensorFlow.

Tensorflow Transfer Learning Model for Image Classification
Image Classification Project - Build an Image Classification Model on a Dataset of T-Shirt Images for Binary Classification

NLP Project for Beginners on Text Processing and Classification
This Project Explains the Basic Text Preprocessing and How to Build a Classification Model in Python