Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

techvarun
Valued Contributor 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
Honored Contributor III

Re: Rename Value in Listbox

Techvarun,

Please see the attachment for demo.

Thanks,

AS

7 Replies

Re: Rename Value in Listbox

Try like this:

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

amit_saini
Honored Contributor III

Re: Rename Value in Listbox

Techvarun,

Please see the attachment for demo.

Thanks,

AS

techvarun
Valued Contributor II

Re: Rename Value in Listbox

Thankyou Avinash and Amit

amit_saini
Honored Contributor III

Re: Rename Value in Listbox

Cheers

techvarun
Valued Contributor II

Re: Rename Value in Listbox

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

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

techvarun
Valued Contributor II

Re: Rename Value in Listbox

Thanks a lot Aninash

Community Browser