Navigation:  Formula Reference > ApplyBI Formula Functions >

QNEXTDATA

Previous pageReturn to chapter overviewNext page

 

This function returns the next record of a dimension or measure.

Syntax

QNEXTDATA("Expression", "Key Value", "Default Value")

Arguments

This function has these arguments:

Argument

Description

Expression

The name of dimension or measure.

Key Value

The cell name referring to the dimension or measure

Default Value

The returned value if the result of the function is null.

 

Data Types

The "Expression" argument accepts dimension or measure values from the drop down menu.

The "Key Value" argument accepts cell name values(you can use the + button after clicking on a specific cell).

The "Default Value" argument accepts alphanumeric values.

 

Returns same data type as "Expression" type.

 

Examples

QNEXTDATA("Customer",B3,"0"). This example will return the next record of the "Customer" dimension value being in the B3 cell.

If the result is null then the returned value is 0.

 

See Also

QPREVDATA