Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Tags (1)
5 Replies

Re: Listbox showing non distinct values

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

Re: Listbox showing non distinct values

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

Re: Listbox showing non distinct values

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

='[' & %ItemID & ']'

to include start/end-markers.

shiveshsingh
Honored Contributor

Re: Listbox showing non distinct values

Are there any more values after these 2 strings?

Partner
Partner

Re: Listbox showing non distinct values

Hi Sunny,

Function Trim() did the trick.

Thanks

Paul