topic Re: Change column name in more than 100 variables in App Development

Change column name in more than 100 variables

madnanansari — Sun, 29 Oct 2017 10:13:20 GMT

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?

Re: Change column name in more than 100 variables

rubenmarin — Sun, 29 Oct 2017 10:26:16 GMT

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

Re: Change column name in more than 100 variables

sharpjoki — Sun, 29 Oct 2017 10:56:13 GMT

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

Re: Change column name in more than 100 variables

sharpjoki — Sun, 29 Oct 2017 10:58:53 GMT

Look at here: Renaming fields using variable

Re: Change column name in more than 100 variables

madnanansari — Sun, 29 Oct 2017 11:06:48 GMT

where do i find configuration?

Re: Change column name in more than 100 variables

rubenmarin — Sun, 29 Oct 2017 13:12:31 GMT

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

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

Re: Change column name in more than 100 variables

madnanansari — Sun, 29 Oct 2017 14:22:54 GMT

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

Re: Change column name in more than 100 variables

rubenmarin — Sun, 29 Oct 2017 19:28:58 GMT

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