topic Difference between getobjectfield and getcurrentfield functions in QlikView

Difference between getobjectfield and getcurrentfield functions

Wed, 19 Dec 2012 13:15:13 GMT

Hi folks,

Can any one let me know the difference between getobjectfield() and getcurrentfield() functions with examples.

Many Thanks!

Surendra

Re: Difference between getobjectfield and getcurrentfield functions

Gysbert_Wassenaar — Wed, 19 Dec 2012 13:29:20 GMT

getobjectfield(0) returns the name of the first dimension of the chart the expression is used in. getobjectfield(1) returns the name of the second dimension, etc.

getcurrentfield returns the currently active field in a cyclic or drill down group. Since groups are independant of charts, the getcurrentfield function can also be used in expressions that are not used in a chart, but for example a text box.

Re: Difference between getobjectfield and getcurrentfield functions

Wed, 19 Dec 2012 13:58:16 GMT

Thanks Gysbert. I've understood the use of getcurrentfield function completely. I understood from you that getobjectfield is used in charts only. Can you give an example for expression that works with getobjectfield and also let me know the scenarios in which getobjectfield is used.

Re: Difference between getobjectfield and getcurrentfield functions

Fri, 29 Apr 2016 10:54:57 GMT

This functions does not seem exist/to work in Qlik Sense? GetObjectField does not work and GetCurrentField does not exist.

I am trying to get the active field in a drill down dimension to calculate an average reference line using the AGGR by the active field in the drill down dimension.

Re: Difference between getobjectfield and getcurrentfield functions

shannonmarshall — Tue, 16 Aug 2016 13:02:14 GMT

Is there a way to use GetObjectCode as a ListBox to show just the columns in a particular chart? What I am trying to do is give the user a vertical list of the columns used in a table so they can see it at a quick glance and not have to always scroll through the table.

Re: Difference between getobjectfield and getcurrentfield functions

Anonymous — Sun, 20 Nov 2016 16:00:33 GMT

This function do available in Qliksense too,

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/SystemFunctions/GetObjectField.htm

Re: Difference between getobjectfield and getcurrentfield functions

trdandamudi — Mon, 21 Nov 2016 00:47:58 GMT

Here is an example regarding GetObjectField() and hope this helps...

Remember the index starts at 0 =GetObjectField(2,'CH02')

GetObjectField() will return the field name and not the contents. If you need the value in that particular column, Then use the below expression :

=concat(Distinct $(=GetObjectField(2,'CH02')),',')