How to transfer a data or table from QlikView to Excel

This recipe helps you transfer a data or table from QlikView to Excel

Recipe Objective: How to transfer data or table from QlikView to Excel?

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.

Step 3:

On the bottom New Document option is available. By clicking on the New Document option, a Wizard will get opened.

Learn How to Build a Simple Chatbot from Scratch in Python (using NLTK)

Step 4:

Now Select Data Source-> Browse->Select file from the folder, here an excel file named as "Coffee Chain Sales" is being selected->then click on Next step. Now under Data Presentation->select "Use column headers for data file," then click on the Next step option and Save the file at a location/folder with the name of choice. Here, the file name is given as "qlik2" Then, click on the Next step option again.

Step 5:

Now under the Chart type tab, Select the Bar chart->click on Next step option->Populate Chart->Select Dimension as "Product"->under Expression tab select->Calculate the sum of->Coffee Sales, then click on Next step option.

Step 6:

Now under the Selections tab->Select Table Box->Create. The Bar Chart with table box will be available in the Main sheet/QlikView Document. Now click on the "XL"(Send to excel) button available at the top right corner of the table/chart so that the data will get transferred to excel.

What Users are saying..

profile image

Savvy Sahai

Data Science Intern, Capgemini
linkedin profile url

As a student looking to break into the field of data engineering and data science, one can get really confused as to which path to take. Very few ways to do it are Google, YouTube, etc. I was one of... Read More

Relevant Projects

Learn to Build an End-to-End Machine Learning Pipeline - Part 2
In this Machine Learning Project, you will learn how to build an end-to-end machine learning pipeline for predicting truck delays, incorporating Hopsworks' feature store and Weights and Biases for model experimentation.

AWS Project to Build and Deploy LSTM Model with Sagemaker
In this AWS Sagemaker Project, you will learn to build a LSTM model on Sagemaker for sales forecasting while analyzing the impact of weather conditions on Sales.

NLP and Deep Learning For Fake News Classification in Python
In this project you will use Python to implement various machine learning methods( RNN, LSTM, GRU) for fake news classification.

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.

Build CNN for Image Colorization using Deep Transfer Learning
Image Processing Project -Train a model for colorization to make grayscale images colorful using convolutional autoencoders.

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.

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.

Insurance Pricing Forecast Using XGBoost Regressor
In this project, we are going to talk about insurance forecast by using linear and xgboost regression techniques.

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.

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