Expression to rename two values in a list box

[ak00428233]

Hi All,

I an new to qlikview can you please help me in renaming two values in a list box.

Jobs:

LOAD * INLINE [

Professions,

Doctor

Teacher

Engineer

Professor

IndianAdministrativeService

IndianForeignService

];

Required:-

I want to rename IndianAdministrativeService and IndianForeignService to be renamed as IAS and IFS in the listbox using the expression in listbox.

Can you please guide me.

Thanks in advance

Regards,

Anu

[Anonymous · Accepted solution]

=if(Professions='IndianAdministrativeService','IAS',
if(Professions='IndianForeignService','IFS',Professions))

[Anil_Babu_Samineni]

This?

If(Pick(Match(Professions, 'IndianAdministrativeService', 'IndianForeignService'), 'IAS','IFS'), Professionals)

[ak00428233]

Thank you so much John

[ak00428233]

I dont know why but it is not working anil.....

[Anil_Babu_Samineni]

Try this Perhaps

Pick(Match(Professions, 'IndianAdministrativeService', 'IndianForeignService'), 'IAS','IFS', Professions)

[ak00428233]

Hi Anil,

Thank you
It is working but rest of the values are not visible by using this expression.

[Anil_Babu_Samineni]

May be i need to test that, Anyway you got work around.

[Anil_Babu_Samineni]

Test done, This should work

=Pick(Match(Professions, 'IndianAdministrativeService', 'IndianForeignService')+1, Professions, 'IAS','IFS')