What is the use Accumulation for a chart in QlikView

This recipe explains what is the use Accumulation for a chart in QlikView

Recipe Objective:-What is the use of Accumulation for a chart 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" 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->then click on Next->Next->Next->Finish.The Bar chart will be then available in the Main sheet/QlikView Document.

Step 5:-

Now go to Bar chart in the Main sheet->Right click->Properties->Expression tab->Click on Full Accumulation-> Or if we want to provide accumulation in steps, then->Click on Accumulate->Select the steps to accumulate->then click on Apply and Ok.No accumulation is by default selected when the chart appears in the Main sheet, thus accumulation can be changed from the Properties and Expression tab.

Step 6:-

Therefore in this way, the Bar chart with Accumulation will be available in the Main sheet/QlikView document.

What Users are saying..

profile image

Ed Godalle

Director Data Analytics at EY / EY Tech
linkedin profile url

I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More

Relevant Projects

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

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.

Recommender System Machine Learning Project for Beginners-4
Collaborative Filtering Recommender System Project - Comparison of different model based and memory based methods to build recommendation system using collaborative filtering.

Loan Eligibility Prediction in Python using H2O.ai
In this loan prediction project you will build predictive models in Python using H2O.ai to predict if an applicant is able to repay the loan or not.

Ola Bike Rides Request Demand Forecast
Given big data at taxi service (ride-hailing) i.e. OLA, you will learn multi-step time series forecasting and clustering with Mini-Batch K-means Algorithm on geospatial data to predict future ride requests for a particular region at a given time.

BERT Text Classification using DistilBERT and ALBERT Models
This Project Explains how to perform Text Classification using ALBERT and DistilBERT

Build a Multi ClassText Classification Model using Naive Bayes
Implement the Naive Bayes Algorithm to build a multi class text classification model in Python.

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

Learn to Build Generative Models Using PyTorch Autoencoders
In this deep learning project, you will learn how to build a Generative Model using Autoencoders in PyTorch

Build a Hybrid Recommender System in Python using LightFM
In this Recommender System project, you will build a hybrid recommender system in Python using LightFM .