Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

matheus_silva
Contributor

GetObjectField()

Hi.

    I need get a value of the object calculed already, and sum with other value calculed too. With GetObjectField(0,'CH110')  a can get the dimension os object, but if i want get a column, for example:

Capturar.JPG

GetObjectField(0,'CH110')     ===== 'Furto'


But I need the 300.065, how i can get?

Thanks.

1 Solution

Accepted Solutions

Re: GetObjectField()

You reference an already calculated column within the same object using function

Column(n)

Where n is the number of the expression column -- 1 being the first expression and so on.

You may not reference the column value from another object.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

6 Replies
vasilevtodor
New Contributor II

Re: GetObjectField()

If(GetObjectField(0,'CH110') = COLUMN1, SUM(COLUMN2))

I guess this could help you

matheus_silva
Contributor

Re: GetObjectField()

Not works.

GetObjectField(0,'CH110') return a string...I need a index of columns.

vishsaggi
Esteemed Contributor III

Re: GetObjectField()

Can you share some sample data and what you are expected output should be?

matheus_silva
Contributor

Re: GetObjectField()

Attached.

Thanks.

Re: GetObjectField()

You reference an already calculated column within the same object using function

Column(n)

Where n is the number of the expression column -- 1 being the first expression and so on.

You may not reference the column value from another object.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

vishsaggi
Esteemed Contributor III

Re: GetObjectField()

I am not sure if i understand you correctly. May be you can use this expr to get 78. Like

= Sum(Aggr(Sum(VALOR), DCTO))

Capture.PNG

Is it not what you looking for?