Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

madnanansari
New Contributor III

Change column name in more than 100 variables

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?

7 Replies

Re: Change column name in more than 100 variables

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

sharpjoki
New Contributor II

Re: Change column name in more than 100 variables

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
New Contributor II

Re: Change column name in more than 100 variables

madnanansari
New Contributor III

Re: Change column name in more than 100 variables

where do i find configuration?

Re: Change column name in more than 100 variables

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
New Contributor III

Re: Change column name in more than 100 variables

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

Re: Change column name in more than 100 variables

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])

Community Browser