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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Duplicates

How do I  make sure columns in a table do  not have duplicates without using aggregate functions 'sum', count', 'average'?

Thanks for your suggestions

1 Reply
Vegar
MVP
MVP

You can do this in different ways, depending on your needs. Please examine the different outputs in the two screenshots below. 

Where not exists(Field)

image.png

Where not exists(Row)

image.png