topic Re: Get value of dimension like Column()? in App Development

Get value of dimension like Column()?

fzalexanderjohn — Sat, 16 Nov 2024 01:46:55 GMT

The function column() is defined like so:

Column() returns the value found in the column corresponding to ColumnNo in a straight table, disregarding dimensions. For example Column(2) returns the value of the second measure column.

Is there a similar way to get the value of a dimension in a table or chart?

Re: Get value of dimension like Column()?

colinodonnel — Wed, 28 Jun 2023 12:39:47 GMT

=[$(=GetObjectDimension())]

GetObjectDimension - chart function | Qlik Sense on Windows Help

Re: Get value of dimension like Column()?

colinodonnel — Wed, 28 Jun 2023 14:00:31 GMT

[$(=Replace(GetObjectField(0),']',']]'))]

if you want to reference the first dimension in a formula. Ignore any errors