Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

Re: Index Function

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

Highlighted
Employee
Employee

Re: Index Function

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