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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!

Labels (1)
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.