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

12 Replies
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

Anonymous
Not applicable
Author

Can we say this as limitation?

Thanks

Kiran

hic
Former Employee
Former Employee

No, it is rather a question about what is theoretically possible. In this case, there is no way for QlikView to “know” which field is which, without making an analysis of the field values before and after the script run. And this, QlikView doesn't do.

The logic is simple: If you keep the names the same, but change the order, e.g.

  A, B, C, D  -->  A, D, C, B

then it works. And if you keep the order and change one or several field names, e.g.

  A, B, C, D  -->  A, E, C, F

then it also works.

But if you make more complex changes, it doesn't work.

HIC