Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

table box - remove ALL duplicate values

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.wIDDerivate1.wIDDerivate2.wID

A

A
B
CBD
ABA
AB

to this table:

Derivate.wIDDerivate1.wIDDerivate2.wID
A
B
C
D

Thanks for your help in advance!

2 Replies
Not applicable
Author

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.

Not applicable
Author

Thanks Rebecca,

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