topic Re: table box - remove ALL duplicate values in QlikView

table box - remove ALL duplicate values

Wed, 09 Jan 2013 16:56:56 GMT

Hi,

as a work around to my other problem posted, I tried to setup a table box and load data into it. Since it's a combination of multiple list boxes it will only show unique LINES. But I need to get only the unique VALUES or CELLs (so a value will only appear once in the whole table box).

As an example I'd like to get from the following table

Derivate.wID	Derivate1.wID	Derivate2.wID
A	A
B
C	B	D
A	B	A
A	B

to this table:

Derivate.wID	Derivate1.wID	Derivate2.wID
A
B
C
D

Thanks for your help in advance!

Re: table box - remove ALL duplicate values

Wed, 09 Jan 2013 17:20:27 GMT

See if this is sort of what you are looking for. I am a little unclear on what you would want the remaining two fields to contain, but this provides a list of ALL distinct values from ALL three fields.

Re: table box - remove ALL duplicate values

Mon, 14 Jan 2013 09:12:52 GMT

Thanks Rebecca,

due to changed requirementes I won't pursuit this problem any longer.