Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello Experts,
For user convenience I am chaning Column name in script.
Is there anyway it will automatically replace old to new one in dimension and expressions of charts.
Thanks
Kiran
 
					
				
		
.png) hic
		
			hic
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Because you change both name and load order. "Sales" is already loaded in the first table, whereas Sales_Update is loaded in the second.
HIC
 Gysbert_Wassena
		
			Gysbert_WassenaChanging field names will automatically be updated after a reload in charts and (most) expressions, but not in variables.
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If you change the name in script and reload, then the changed name will automatically reflect in dimension and expression
 
					
				
		
 rustyfishbones
		
			rustyfishbones
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		It should do this automatically once you change in the Script and Reload the Data
 
					
				
		
It's not happing in my end. I am using it in set expression.
I am working QV 11 SR 6 v3ersion.
Is this req, any setting?
 
					
				
		
What I found is that if column name is allready aliase with diffrent name and I am chaning that again,It won't change automatically in chart.
it's only work if you are doing rename 1st time.
Please let me know is there a way to it will reflect all the time
Thaanks & Regards,
Kiran Kokade
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		It will reflect all the time automatically. Can you post sample qvw and column which you are facing issue
 
					
				
		
Please check attached file.
 
					
				
		
.png) hic
		
			hic
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		It works on my computer.
First, you need to rename the field back to Sales_Update, so that QlikView "finds" the mapping again. Once this is done, you can rename the field in the script again, and then it works.
What has happened is probably that you renamed and added a field at the same time, and then the field mapping is lost.
HIC
 
					
				
		
What I found is if I rename and after that if I remove rename or keep original name as rename.It won't update original name.
For e.g If original name is Sales1st
1.I am update it Sales as Sales_Update and reload it works.
2.Then I again update Sales as Sales and reload it then it won't update Sales_Update to Sales.
I know this is find quiete silly but I just want to understant why it's not working if I remove aliase.
Thanks
Kiran.
