Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Update column names in expression

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

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

View solution in original post

12 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Changing field names will automatically be updated after a reload in charts and (most) expressions, but not in variables.


talk is cheap, supply exceeds demand
anbu1984
Master III
Master III

If you change the name in script and reload, then the changed name will automatically reflect in dimension and expression

rustyfishbones
Master II
Master II

It should do this automatically once you change in the Script and Reload the Data

Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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
Master III
Master III

It will reflect all the time automatically. Can you post sample qvw and column which you are facing issue

Anonymous
Not applicable
Author

Please check attached file.

hic
Former Employee
Former Employee

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

Anonymous
Not applicable
Author

Henric Cronström

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.