Navigation:  Formula Reference > ApplyBI Formula Functions >

QGETDATA

Previous pageReturn to chapter overviewNext page

 

This function returns the value of a dimension or measure based on its record number.

Syntax

QGETDATA("Expression ","Record Number","Default Value",

               "Dimension 1 Filter Name","Dimension 1 Filter Value",

               "Dimension n Filter Name","Dimension n Filter Value" )

Arguments

This function has these arguments:

Argument

Description

Expression

The name of dimension or measure.

Record Number

The record number of the expression

Default Value

The returned value if the result is null.

Dimension 1-n Filter Name

The dimension(s) based on which the expression will be evaluated

Dimension 1-n Filter Value

The value of the dimension(s) based on which the expression will be evaluated

 

Data Types

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

The "Record Number" argument accepts numeric values.

The "Default Value" argument accepts alphanumeric values.

The "Dimension 1-n Filter Name" argument accepts accepts dimension or measure values from the drop down menu

The "Dimension 1-n Filter Value" argument accepts cell name values(you can use the + button after clicking on a specific cell)..

 

Returns same data type as "Expression" type.

 

Examples

QGETDATA("Customer","8","0"). This example will return the value of the "Customer" dimension with the record number 8 .

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

QGETDATA("Customer","8","0","Country","15"). This example will return the value of the "Customer" dimension with the record number 8  filtering by the "Country" dimension with the record number 15.

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

 

See Also

QAGGRDATA