Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
techvarun
Specialist II
Specialist II

Rename Value in Listbox

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

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Techvarun,

Please see the attachment for demo.

Thanks,

AS

View solution in original post

7 Replies
avinashelite

Try like this:

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

amit_saini
Master III
Master III

Techvarun,

Please see the attachment for demo.

Thanks,

AS

techvarun
Specialist II
Specialist II
Author

Thankyou Avinash and Amit

amit_saini
Master III
Master III

Cheers

techvarun
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

Thanks a lot Aninash