topic Re: Listbox showing non distinct values in QlikView

Listbox showing non distinct values

phamensink — Wed, 25 Nov 2020 16:16:04 GMT

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

Can anyone please explain this?

sunny_talwar — Fri, 02 Feb 2018 17:01:12 GMT

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

Peter_Cammaert — Fri, 02 Feb 2018 17:06:44 GMT

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 — Fri, 02 Feb 2018 17:08:40 GMT

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

='[' & %ItemID & ']'

to include start/end-markers.

shiveshsingh — Sat, 03 Feb 2018 02:57:00 GMT

Are there any more values after these 2 strings?

phamensink — Wed, 07 Feb 2018 12:30:42 GMT

Hi Sunny,

Function Trim() did the trick.

Thanks

Paul