topic Re: dynamic column names in Aggr in QlikView

dynamic column names in Aggr

ali_hijazi — Thu, 21 Jun 2012 12:45:40 GMT

Hello

I have an expression in a pivot table as follows:

if(

min(aggr($(=vSales_Variance),[Geo Country],[Brand Group]))<0,

'qmem://<bundled>/BuiltIn/arrow_e.png')

the Columns [Geo Country] and [Brand Groups] I can get their names respectively using the following:

'[' & GetObjectField(Dimensionality()-1) & ']'

however when I use '[' & GetObjectField(Dimensionality()-1) & ']' in the above aggregation the expression doesn't work

Please advise

Fri, 28 Sep 2012 12:03:51 GMT

up!

need it too

whiteline — Fri, 28 Sep 2012 15:31:21 GMT

Hi.

The field name should be calculated before the expresison starts calculating.

Use $() statement, something like this:

$(='[' & GetObjectField(Dimensionality()-1) & ']')