Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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?