ABOVE AND BELOW FUNCTIONS?

[#1]

ABOVE AND BELOW FUNCTIONS?

[#2]

above([ total ] expression [ , offset [,n ]])

Returns the value of expression evaluated with the chart's dimension values as they appear on the row above the current row within a column segment in a table or, in the case of bitmap charts, in the chart's straight table equivalent (Actually all QlikView charts have a straight table equivalent with the exception of the pivot table which has a more complex structure.).

On the first row of a column segment a NULL value will be returned, as there is no row above this one.

[#3]

below([ total ] expression [ , offset [,n ]])

Returns the value of expression evaluated with the chart's dimension values as they appear on the row below the current row within a column segment in a table or, in the case of bitmap charts, in the chart's straight table equivalent.

On the last row of a column segment a NULL value will be returned, as there is no row below this one.

[#4]

Above simply takes a value from the row Above the current row. It can be used to calculate an accumulating total.

Here are some quick examples.

Above(Column(1))

Above(TOTAL Column(1)) + If(Above(TOTAL Column(3)) > 0, Above(TOTAL Column(3)), 0)

and also check below link

Using Above/Below functions in Expressions on a table

[#5]

Go through the Qlikview Reference Manual,  you will get enough stuff there..