topic Re: GetObjectField Syntax in QlikView

GetObjectField Syntax

Thu, 11 Jun 2015 21:56:17 GMT

Hi,

I have an Object with ID CH28 and i need to pull the entire column 3 (index 3 if i am not mistaken). I am having issues using the GetObjectField function. Can someone please help me with the syntax ,

eg (see below)

CH 28 [Object id and need to pull values for xyz column]

Header 1	Header 2	xyz	Header 4	Header 5
	.. . . . .	1 2 4 5

Header 1

Header 2

xyz

Header 4

Header 5

Thank you for the assistance,

Best,

Nik

Re: GetObjectField Syntax

sorrakis01 — Thu, 11 Jun 2015 23:42:37 GMT

Hi,

I think in simple table doesn't works. Change the object (try in a chart table (straight or pivot) ).

Remember the index starts at 0 in your case it's =GetObjectField(2,'CH28')

Regards

Re: GetObjectField Syntax

Thu, 11 Jun 2015 23:48:36 GMT

Thank you. So if i write =GetObjectField(2,'Objectid') as an expression in a separate straight table or a chart , I will have the entire column with index 2 pulled in? Thanks again for your help.

Re: GetObjectField Syntax

rwunderlich — Fri, 12 Jun 2015 03:20:25 GMT

GetObjectField() returns the Field name, not the contents. If you want the values in that column, something like this:

=concat(DISTINCT $(=GetObjectField(1,'CH51')),',')

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: GetObjectField Syntax

pratap6699 — Fri, 12 Jun 2015 06:22:35 GMT

GetObjectField() returns the Field name or groupname, not the contents.

ex:GetObjectField(index,'objectid') it returns the specific field or group from index on object

Re: GetObjectField Syntax

Fri, 12 Jun 2015 14:49:33 GMT

Thank you for the help, Appreciate it.