Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ABOVE AND BELOW FUNCTIONS?
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.
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.
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
Go through the Qlikview Reference Manual, you will get enough stuff there..