use of Above() and Below()

[qv_testing]

Hi All,

Use of Above and Below, please give Example.

Thanks....

Raju

[vikasmahajan]

Study this Qvw

[er_mohit]

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 image charts, in the chart's

straight table equivalent.

function with the corresponding positive offset. An offset of 0 will

evaluate the expression on the row of the expression itself. Recursive

calls will return NULL.

Examples:

sum( Sales )/above( sum( Sales ))

above( sum( Sales ), 2 )

above( total sum( Sales ))

rangeavg (above(sum( x ),1,3,)) returns an average of the three

results of the sum function evaluated on the three rows immediately

above the current row.

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 image 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.

Examples:

below( sum( Sales ))

below( sum( Sales ), 2 )

below( total sum( Sales ))

rangeavg (below(sum( x ),1,3)) returns an average of the three

results of the sum function evaluated on the three rows immediately

below the current row.

[#4]

hi

Above() and Below() function both are used in expression side .

Note that both functions are used on the data of single Column.