December 2018
Beginner to intermediate
786 pages
17h 4m
English
One of the most powerful features in QlikView is the ability to create vertical calculations in charts. We normally calculate values horizontally, where all values are in reference to the dimensions in the chart. It is a very important feature for us to also make vertical calculations across those horizontal numbers. For example, we might want to know what the total of all our calculations is so that we can calculate a ratio.
We might want to know the average, or the standard deviation, to draw a line in a chart. We might want to accumulate just the last four results to calculate a rolling average.
There are several functions that allow us to compare between different records in a chart. ...
Read now
Unlock full access