topic Re: ABOVE AND BELOW FUNCTIONS? in QlikView

ABOVE AND BELOW FUNCTIONS?

Mon, 23 Jun 2014 10:30:08 GMT

ABOVE AND BELOW FUNCTIONS?

Re: ABOVE AND BELOW FUNCTIONS?

Mon, 23 Jun 2014 11:57:12 GMT

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.

Re: ABOVE AND BELOW FUNCTIONS?

Mon, 23 Jun 2014 11:57:24 GMT

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.

Re: ABOVE AND BELOW FUNCTIONS?

Mon, 23 Jun 2014 12:03:46 GMT

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

Re: ABOVE AND BELOW FUNCTIONS?

Mon, 23 Jun 2014 12:11:53 GMT

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