Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
phamensink
Partner
Partner

Listbox showing non distinct values

I always thought that a listbox in Qlikview showed distinct values, however I have one that doesn't.

Can anyone please explain this?

Knipsel.PNG

5 Replies
sunny_talwar

May be there is extra space that might make the two different. Can you try Trim(%ItemID) as %ItemID in the script?

Peter_Cammaert
Partner
Partner

The horizontal scroll-bar at the bottom is an ominous sign. What comes at the far right of all those codes? Other text?

Peter_Cammaert
Partner
Partner

Using an alternative to what Sunny suggested, you could change the listbox field into something like

='[' & %ItemID & ']'

to include start/end-markers.

shiveshsingh
Master
Master

Are there any more values after these 2 strings?

phamensink
Partner
Partner
Author

Hi Sunny,

Function Trim() did the trick.

Thanks

Paul