O'Reilly logo

Mastering QlikView by Stephen Redmond

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating vertically

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.

Using inter-record and range functions

There are several functions that allow us to compare between different records in a chart. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required