Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Create a var using num(Sum(sales)) and use it into your table and your textbox