topic Re: GetObjectField() in QlikView

GetObjectField()

Anonymous — Tue, 26 Sep 2017 14:00:13 GMT

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:

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

But I need the 300.065, how i can get?

Thanks.

Re: GetObjectField()

Anonymous — Tue, 26 Sep 2017 14:15:03 GMT

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

I guess this could help you

Re: GetObjectField()

Anonymous — Tue, 26 Sep 2017 16:32:16 GMT

Not works.

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

Re: GetObjectField()

vishsaggi — Tue, 26 Sep 2017 17:05:40 GMT

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

Re: GetObjectField()

Anonymous — Tue, 26 Sep 2017 18:02:41 GMT

Attached.

Thanks.

Re: GetObjectField()

rwunderlich — Tue, 26 Sep 2017 18:17:26 GMT

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

Re: GetObjectField()

vishsaggi — Tue, 26 Sep 2017 19:14:27 GMT

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))

Is it not what you looking for?