Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

guyvermeiren
Contributor

Replacing field in all expressions (Qlik Sense)

Hello,

Is there a way in Qlik Sense to replace all the fields in all expressions in an app by a new field.

The reason is that the fieldname has changed.

Thanks,

Guy

Labels (1)
5 Replies
MVP & Luminary
MVP & Luminary

Re: Replacing field in all expressions (Qlik Sense)

Yes, you can replace the field by editing all the relevant expressions manually.

Perhaps it's possible to use the QS API. It's at least possible to export the app definition to a json file. You can then edit the json file to replace the field names. See https://github.com/countnazgul/QS-backup-and-restore-app for an example implementation of the json backup-restore mechanism


talk is cheap, supply exceeds demand
pradosh_thakur
Honored Contributor II

Re: Replacing field in all expressions (Qlik Sense)

Never tried this, may be wont work as well

let say your field name was "abc" and now changed to "abc1" . If you create a master item name "abc" may be it will do the trick. Try it and let me know if it works or not.
Learning never stops.
guyvermeiren
Contributor

Re: Replacing field in all expressions (Qlik Sense)

What you are suggesting is to re-create the field and give it the former (old) name ??

Correct ??

pradosh_thakur
Honored Contributor II

Re: Replacing field in all expressions (Qlik Sense)

I am asking you to create a master item with the old name. not a field as you need the field to be re-named.
Learning never stops.
mark6505
Valued Contributor III

Re: Replacing field in all expressions (Qlik Sense)

Hi,

I may be over simplifying , but can you not just alias the new field name to the old one it script?

I.e.

NewField  AS OldFIeld

Mark