Navigation:  Formula Reference > ApplyBI Formula Functions >

QGETDIM

Previous pageReturn to chapter overviewNext page

 

This function returns an array of values of a specific dimension

Syntax

QGETDIM("Expression", RecordCount)

Arguments

This function has these arguments:

Argument

Description

Expression

The name of dimension or measure.

RecordCount

The number of the returned records.

 

Data Types

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

The "Record Number" argument accepts numeric values.

 

Returns array of data.

Examples

QGETDIM("Customer",10). This example will return an array with the first 10 values (ascending) of the dimension "Customer".

 

See Also

QGETDATA