How to add a table from an excel sheet to the QlikView window

This recipe helps you add a table from an excel sheet to the QlikView window

Recipe Objective: How to add a table from an excel sheet to the QlikView window?

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:

Open the Main sheet document->Go to menu bar->Click on File menu->Go to Edit Script->Data tab->select Table Files.

Step 3:

Now select the excel file from the folder; here, a file named "Sample-sales-data-excel" is selected->select 50 orders from tables->Finish-> a code will be displayed in the edit script window->click on Ok.

Learn How to Build a Multi Class Text Classification Model using BERT

Step 4:

Now click on Reload button from the Menu bar->Save the file with the name of choice at a location/folder, the data will get loaded.

Step 5:

Now go to Main Sheet->Right click->New sheet object->Table box->select 50 orders->from show fields from table option.

Step 6:

From the Available Fields tab->Click on Add all->all fields will get added->click on Apply and Ok->Table will get added 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

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.

Build Regression (Linear,Ridge,Lasso) Models in NumPy Python
In this machine learning regression project, you will learn to build NumPy Regression Models (Linear Regression, Ridge Regression, Lasso Regression) from Scratch.

Avocado Machine Learning Project Python for Price Prediction
In this ML Project, you will use the Avocado dataset to build a machine learning model to predict the average price of avocado which is continuous in nature based on region and varieties of avocado.

Recommender System Machine Learning Project for Beginners-1
Recommender System Machine Learning Project for Beginners - Learn how to design, implement and train a rule-based recommender system in Python

Learn Object Tracking (SOT, MOT) using OpenCV and Python
Get Started with Object Tracking using OpenCV and Python - Learn to implement Multiple Instance Learning Tracker (MIL) algorithm, Generic Object Tracking Using Regression Networks Tracker (GOTURN) algorithm, Kernelized Correlation Filters Tracker (KCF) algorithm, Tracking, Learning, Detection Tracker (TLD) algorithm for single and multiple object tracking from various video clips.

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.

Time Series Python Project using Greykite and Neural Prophet
In this time series project, you will forecast Walmart sales over time using the powerful, fast, and flexible time series forecasting library Greykite that helps automate time series problems.

NLP Project to Build a Resume Parser in Python using Spacy
Use the popular Spacy NLP python library for OCR and text classification to build a Resume Parser in Python.

Locality Sensitive Hashing Python Code for Look-Alike Modelling
In this deep learning project, you will find similar images (lookalikes) using deep learning and locality sensitive hashing to find customers who are most likely to click on an ad.

House Price Prediction Project using Machine Learning in Python
Use the Zillow Zestimate Dataset to build a machine learning model for house price prediction.