QlikView App Dev

[wkolbnik]

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?

[sunny_talwar]

May be see if this helps

$(=GetObjectField(0))

[wkolbnik]

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

[sunny_talwar]

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