Introduction

Simple, straightforward aggregation functions are the staple of QlikView. Nine times out of ten, we tend to use something like Sum(), Count(), or Avg(). We might add in some Set Analysis, but the basic function is the same.

We usually call these "horizontal" functions, because they are calculated on the row, in the chart for the dimension on that row. So, we calculate the sum of sales for each country, or we count the number of purchase orders for each year.

From time-to-time, we need to break out of the row and perform "vertical" calculations. For these, we need to look at more advanced aggregation functions using TOTAL, AGGR, or one of the range functions.