Solved: How to merge team member name as one in List Box - Qlik Community

Permalink · ‎2014-01-14

Hi,

I have Team member with same name as Micheal Sunie and Micheal Sunie MFR in List box. My user wnats to have only Micheal Sunie MFR in List box.

Could anyone help me is there any way to merge theses two and have only Micheal Sunie MFR.

Thanks.

rustyfishbones · ‎2014-01-14

try using REPLACE() in the script

REPLACE(Team Member,'Michael Sunie','Michael Sunie MRF') as Team Member

View solution in original post

vikasmahajan · ‎2014-01-14

You can use apply Map command if members are in less size.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Permalink · ‎2014-01-14

Thanks and how can I use Map command?please tell me

richard · ‎2014-01-14

This is dataquality issue of which I would also advise to use the apply map in your script and not in the listbox.

See the help function for the applymap function. It's easy!

sujeetsingh · ‎2014-01-14

Amelia

Can you please provide details of all name in the list .

Or it just for one name

sujeetsingh · ‎2014-01-14

Guys you all are saying to have applymap but one thing i want to ensure is that whether the the last thre characters are always three or they lack consistency if it is so then what is the logic behind applying the Applymap()

richard · ‎2014-01-14

ApplyMap() could be the best alternative by not knowing what context we are having to deal with here.

On the other hand, you're right about using a string function to remove the last x amount of characters.

Permalink · ‎2014-01-14

Hi Thanks and it is only for one name Micheal Sunie. Any help please

Permalink · ‎2014-01-14

How can I remove last Three charactres in LIST BOX?please tell me

Permalink · ‎2014-01-14

Please help me as this is urgent task to me to set please