Change column name in more than 100 variables

[madnanansari]

I have an app where there are more than 100 variables mentioning the same column. I would like to change the name of the column in all these variables. Is there any way to do this in one shot?

[rubenmarin]

Hi Mohammad, check in configuration -> Expression preview (CTRL+ALT+E), there you can change many expressions in one shot.

[sharpjoki]

Hey. As far as I know, the expression browser does not display variables. You need to use the rename fields through the mapping table.

[sharpjoki]

Look at here: Renaming fields using variable

[madnanansari]

where do i find configuration?

[rubenmarin]

Press CTRL-ALT+E and the dialog will open.

You can look for expressions and use replace to change the name of the column.

[madnanansari]

I m using Qlik Sense Server. How to do it in the browser?

[rubenmarin]

Ops, sorry, I thought it was a QlikView question, I don't know any similar utility in Sense.

Just to give some tips I use to centralize management of expressions:

- Using the master items.

- Using variables. As a simple example:

LET varName='[Column Name]';

Then the expression can use the variable, switching the variable in one place and all expressions using the varaiable reflects the changes:

Sum($(varName)) // It's the same than write Sum([Column Name])