Solved: Change fieldname in a listbox - Qlik Community

Anonymous · ‎2014-01-21

Hi,

in a listbox there two fields, acc and mon. Is it possible to change the name of this field.

acc -> accumulate

mon -> monthly

Regards

Stefan

pogrebnoymike · ‎2014-01-21

Although I agree with Christian that it is best done in the load script itself, if there is a reason not to do that, you can use the Expression in the list box and go with something along the lines of the following:

" =if(data_evalution = 'acc', 'accumulate',if(data_evalution = 'mon','monthly',data_evalution)) "

Probably worth mentioning that it'll show up as 'acc' or 'mon' in the current selections and elsewhere. So, I guess it's still best to go for the load script.

View solution in original post

Report Inappropriate Content · ‎2014-01-21

Hi Stefan

you should better to this in the script

best regards

Chris

MayilVahanan · ‎2014-01-21

Hi

try like this

Listbox-> Field -> expression

=if(data_evalution='acc', 'accumulate', 'monthly')

But, you need to use so many place,. better change in script itself.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

pogrebnoymike · ‎2014-01-21

Although I agree with Christian that it is best done in the load script itself, if there is a reason not to do that, you can use the Expression in the list box and go with something along the lines of the following:

" =if(data_evalution = 'acc', 'accumulate',if(data_evalution = 'mon','monthly',data_evalution)) "

Probably worth mentioning that it'll show up as 'acc' or 'mon' in the current selections and elsewhere. So, I guess it's still best to go for the load script.