topic Re: Rename Value in Listbox in QlikView

Rename Value in Listbox

techvarun — Wed, 13 Aug 2014 10:26:55 GMT

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

Re: Rename Value in Listbox

avinashelite — Wed, 13 Aug 2014 10:28:55 GMT

Try like this:

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

Re: Rename Value in Listbox

amit_saini — Wed, 13 Aug 2014 10:32:10 GMT

Techvarun,

Please see the attachment for demo.

Thanks,

Re: Rename Value in Listbox

techvarun — Wed, 13 Aug 2014 10:40:31 GMT

Thankyou Avinash and Amit

Re: Rename Value in Listbox

amit_saini — Wed, 13 Aug 2014 10:41:21 GMT

Cheers

Re: Rename Value in Listbox

techvarun — Wed, 13 Aug 2014 11:28:58 GMT

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?

Re: Rename Value in Listbox

avinashelite — Wed, 13 Aug 2014 12:47:07 GMT

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

Re: Rename Value in Listbox

techvarun — Wed, 13 Aug 2014 13:12:23 GMT

Thanks a lot Aninash