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