Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
wkolbnik
New Contributor

GetObjectField() over Calculated Dimention

Hi!

We’ve got a pivot table with calculated dimentions, which after calculation give us such values:

Calculated dimention text

Calculated value

=$(=FirstSortedValue(Dim,Dim_ID,1))

Year

=$(=FirstSortedValue(Dim,Dim_ID,2))

WeekNum

We need to have these calculated values in expression as text.

But GetObjectField() give us Calculated dimention text, like that

Formula

Result

Needed result

But GetObjectField(0)

=$(=FirstSortedValue(Dim,Dim_ID,1))

Year

But GetObjectField(1)

=$(=FirstSortedValue(Dim,Dim_ID,2))

WeekNum

We stack with formula manipulations to get needed results. Is there a workaround with syntactic to solve this problem. Or it is impossible at all?

3 Replies

Re: GetObjectField() over Calculated Dimention

May be see if this helps

$(=GetObjectField(0))

wkolbnik
New Contributor

Re: GetObjectField() over Calculated Dimention

Unfortunately, it returns "2017" and "2016" instead of "Year".

And sorry for not mentioning it before: We need to get executed

GetObjectField(Dimentionality()-1)

not

GetObjectField(0)

It is strange, but $(=GetObjectField(0)) works and returns 2017

But  $(=GetObjectField(Dimentionality()-1)) doesn't work at all

Re: GetObjectField() over Calculated Dimention

Would you be able to share a sample to take a look at this?