Rename Value in Listbox

[techvarun]

Hi Qlikxperts,

                              I have a list box with something around 2500 fields on that particular list box i have one value "LEGAL & CUSTOMER COMMUNICATION" and i want to display only that value as LEGAL & CC.

Thanks in advance

Regds

TechVarun

[avinashelite]

Try like this:

if(filedname='LEGAL & CUSTOMER COMMUNICATION','LEGAL & CC',filedname)

[amit_saini · Accepted solution]

Techvarun,

Please see the attachment for demo.

Thanks,

AS

[techvarun]

Thankyou Avinash and Amit

[amit_saini]

Cheers

[techvarun]

HI all

I am using

= if([Function Name] = 'LEGAL / CORPORATE AFFAIRES', 'LEGAL & CA', Upper([Function Name]))

This in list box expression, but my always selected one value is not working  and function name mapping also disabled..... any idea?

[avinashelite]

Use this expression in the script, this will solve the issue

[techvarun]

Thanks a lot Aninash