Skip to Main Content
Hands-On Business Intelligence with Qlik Sense
book

Hands-On Business Intelligence with Qlik Sense

by Pablo Labbe, Clever Anjos, Kaushik Solanki, Jerry DiMaso
February 2019
Beginner to intermediate content levelBeginner to intermediate
442 pages
9h 38m
English
Packt Publishing
Content preview from Hands-On Business Intelligence with Qlik Sense

As-Of Table

We often get the requirement of calculating rolling averages and accumulations of values over a period of time. And we mostly think of calculating these on the frontend (in chart expressions) using the Above() function. This works fine when we have a small amount of data, but when the data grows, the chart that calculates the accumulations or rolling averages starts affecting performance. In such a situation, it is recommended to move the calculation somehow in the script. The As-Of Table helps to achieve rolling averages and accumulations in the script.

Before we start learning about the As-Of Table, let's understand what accumulations are.

An accumulation is the summation of the data from previous x dimension values, and mostly, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

AI-Powered Business Intelligence

AI-Powered Business Intelligence

Tobias Zwingmann
Data Management at Scale

Data Management at Scale

Piethein Strengholt

Publisher Resources

ISBN: 9781789800944Supplemental Content