Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! 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?