Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
matheus_silva
Creator
Creator

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
rwunderlich
Luminary Alumni
Luminary Alumni

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

View solution in original post

6 Replies
vasilevtodor
Contributor III
Contributor III

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

I guess this could help you

matheus_silva
Creator
Creator
Author

Not works.

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

vishsaggi
Champion III
Champion III

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

matheus_silva
Creator
Creator
Author

Attached.

Thanks.

rwunderlich
Luminary Alumni
Luminary Alumni

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

View solution in original post

vishsaggi
Champion III
Champion III

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?