topic Re: Change fieldname in a listbox in QlikView

Change fieldname in a listbox

Anonymous — Tue, 21 Jan 2014 14:52:04 GMT

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

Re: Change fieldname in a listbox

Tue, 21 Jan 2014 14:57:24 GMT

Hi Stefan

you should better to this in the script

best regards

Chris

Re: Change fieldname in a listbox

MayilVahanan — Tue, 21 Jan 2014 15:01:17 GMT

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.

Re: Change fieldname in a listbox

pogrebnoymike — Tue, 21 Jan 2014 15:03:42 GMT

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.