Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brunopaulo
Partner - Creator II
Partner - Creator II

Index Function

Hello community,

I have a text box displaying a number with function =num(Sum(sales)) so i want use getobjectfield to display that number in other object. Where can i get index of my text box?

any ideas?

Thanks in advance

Best Regards

Bruno Paulo

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

The easiest way to accomplish this is to just repeat the original expression in the new location. QlikVies doesn't let you refer to the results of calculations in another object.

You may think that this is a bit too much to guarantee consistency in your document, if you have to keep repeating expressions in different locations and you're right. The best way forward is to store expressions that are used multiple times in your document in variables. You can do this in the variable overview or - better- in your Load script. That way you create a SPOF (single-point-of-failure) and not multiple ones. You can now edit your expression in a single location, and all instances will change at the same time and in the same way.

Best,

Peter

Clever_Anjos
Employee
Employee

Create a var using num(Sum(sales)) and use it into your table and your textbox