create mulitbox with distinct values

[#1]

Hi,

I am new to Qlikview and struggle with a simple task. I imported a csv-file that looks like this:

Client	ID
x	a
x	b
x	c
y	d
y	e
z	p

Now I want to create a Multibox that lists all clients with at least two (unique) ids like:

Client	ID
x	List(a,b,c)
y	List(d,e)

Any help is appreciated.

[MayilVahanan]

Hi

PFA

In listbox, you can add expression like in attached file

Hope it helps