Can I manually change the text values of a listbox?

[tmagdich]

I have a listbox that pulls data from an Excel file.  This listbox displays data from a section of employees.  My issue is that the file being used to pull data uses an employee ID rather than a direct name.  This causes the listbox to display employee ID's rather that their name. 

Ex:    

Managers

• jsmith1
• tjones12
• jdoe3

Is it possible to manually change these values to look like this:

Managers

• John Smith
• Tom Jones
• Jane Doe

The lists aren't huge, so I figure there must be a way to manually do this through Qlikview.

[sergio0592]

Hi,

In your list box properties, General/Field/Expression and write :

pick(match(Id_Emp, 'jsmith1','tjones12', 'jdoe3'),    'John Smith', 'Tom Jones', 'Jane Doe')

[tmagdich]

I tried this and found a few problems with it as a solution:

1. The employee ID's remain next to the displayed full name

2. The employee name will only display if selected.  Any unselected fields in the list box display only the ID. 

[sergio0592]

Strange, i tried it on a sample before posting and it works.

[Brett_Bleess]

Did you get things fully resolved, or are you still trying to resolve the question?  If the poster's comments did end up working in the end, please mark the post as the solution by clicking the Accept as Solution button.  If you did figure things out, please post what you did, and you can mark that as the solution after posting it.  If you still need further help, provide a further update on things.

That all being said, the easier solution here is likely to update your Excel file with the names in a column next to the IDs and simply pull in that column as your dimension rather than the ID column etc...  This way you have a single place to maintain the data...

Regards,
Brett