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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Is it possible for expressions to pick up renamed fields

Hello

Is it possible for expressions to pick up renamed fields after an expression has been built?

Kind Regards

Helen

3 Replies
jerem1234
Specialist II
Specialist II

If you mean for it change automatically, then no. The expression will still have the old field name. You would have to go back to your expression and change it. You could use a variable to store the field name, and then use that in your expressions. Then you can reduce the amount of times you have to change it. But that might not be worth it if you aren't constantly changing it or only use it a handful of times.

Hope this helps!

Anonymous
Not applicable

In fact, QlikView tries to fix expressions if a field has been renamed.  In some cases it succeeds (I just tried), in some it doesn't.  Don't count on it, especially if you rename multiple fields at once.

Regards,

Michael

jerem1234
Specialist II
Specialist II

Yep Michael is right. I just tested it out too with an Inline table, and sometimes it does and sometimes it doesn't. I noticed as one example that it didn't work when I used the field name in an aggr() function as one of the aggregates. However when I load fields like:

Load *,

Name as Name3

Resident Status;

Then change Name3 to Name4, it didn't work.

Doesn't seem to be consistent.