Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
wkolbnik
Contributor
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
sunny_talwar

May be see if this helps

$(=GetObjectField(0))

wkolbnik
Contributor
Contributor
Author

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?