Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
nazaninslp
New Contributor III

Re: rename fields of list box in expression

Dear Justen
Thank you for your help
how can replace two items in one expression? because I an change the one filed name but can not change more than one.
would you please help?
1 Reply
Highlighted
thiago_justen
Valued Contributor III

Re: rename fields of list box in expression

Try something like this:

If(Match(Area_Category,'DCB',Money_collection'),

Pick(Match(Area_Category,'DCB',Money_collection'),Replace(Area_Category,'DCB','DEDICATED C'),Replace(Area_Category,'Money_collection','M Col'))

,Area_Category)

 

 

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago