unique record list

[#1]

hi

i'm quite new to QlikView and i have a question about unique records.

I made a table with some personal data. Some names are more common.
I want to make a new table what shows how much unique persons there are in the first table.
I made a table with the expression Count(name) now is my question if it's possible that only the unique names will be showed?

i hope someone can help me.

[martin59 · Accepted solution]

Count(Distinct name)

[#3]

expressio:
IF(Count(name)=1,count(name))

this perhaps could do it.

[#4]

this solved my problem thx for the fast reply!

[#5]

Now I got it. You do not want to show only the unique names but all names only once. So Martin did the right thing.