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
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
Changing field names will automatically be updated after a reload in charts and (most) expressions, but not in variables.
If you change the name in script and reload, then the changed name will automatically reflect in dimension and expression
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
It will reflect all the time automatically. Can you post sample qvw and column which you are facing issue
Please check attached file.
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.