topic Re: GetObjectField() over Calculated Dimention in QlikView

GetObjectField() over Calculated Dimention

wkolbnik — Mon, 10 Jul 2017 11:57:06 GMT

Hi!

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

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

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

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 — Mon, 10 Jul 2017 13:07:59 GMT

May be see if this helps

$(=GetObjectField(0))

wkolbnik — Mon, 10 Jul 2017 14:05:13 GMT

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 — Mon, 10 Jul 2017 17:39:37 GMT

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