topic unique record list in QlikView https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163394#M36502 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i'm quite new to QlikView and i have a question about unique records.<BR /><BR />I made a table with some personal data. Some names are more common.<BR />I want to make a new table what shows how much unique persons there are in the first table.<BR />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?</P><P>i hope someone can help me.</P></BODY></HTML> Tue, 11 Jan 2011 11:49:41 GMT 2011-01-11T11:49:41Z unique record list https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163394#M36502 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i'm quite new to QlikView and i have a question about unique records.<BR /><BR />I made a table with some personal data. Some names are more common.<BR />I want to make a new table what shows how much unique persons there are in the first table.<BR />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?</P><P>i hope someone can help me.</P></BODY></HTML> Tue, 11 Jan 2011 11:49:41 GMT https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163394#M36502 2011-01-11T11:49:41Z Re. :unique record list https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163395#M36503 <HTML><HEAD></HEAD><BODY><P>Count(Distinct name)</P></BODY></HTML> Tue, 11 Jan 2011 11:52:34 GMT https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163395#M36503 martin59 2011-01-11T11:52:34Z AW:unique record list https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163396#M36504 <HTML><HEAD></HEAD><BODY><P>expressio:<BR />IF(Count(name)=1,count(name))</P><P>this perhaps could do it.</P></BODY></HTML> Tue, 11 Jan 2011 11:52:41 GMT https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163396#M36504 2011-01-11T11:52:41Z Re. :unique record list https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163397#M36505 <HTML><HEAD></HEAD><BODY><P>this solved my problem thx for the fast reply!</P></BODY></HTML> Tue, 11 Jan 2011 11:57:57 GMT https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163397#M36505 2011-01-11T11:57:57Z AW:Re: Re. :unique record list https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163398#M36506 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 11 Jan 2011 12:11:00 GMT https://community.qlik.com/t5/QlikView/unique-record-list/m-p/163398#M36506 2011-01-11T12:11:00Z