Show duplicate table values

[#1]

Hi.

I'm trying to show duplicate value's only, from a table in my database. What is the best way to realize this in my QV application?

I only want to show all the duplicate email addresses from the table and exclude the rest.

Regards.

[disqr_rm · Accepted solution]

Just create a straight table with email address as dimension and if(count([email address) > 1, 1) as expression. Then you would only see list of emails which have more than one occurences in your data model. Now if you have some other tables linked to this table, this logic may not work.

[#3]

Rakesh,

Thanks for the answer. I tried to apply it and it worked when I remove the '[' from the expression.

So the expression I used looks like this now: if(count(email address) > 1, 1)

This gives all the email addresses the are more than once in the database, in a straight table.

ps. Did you used the [ int the expression with a purpose? Cause QV said the expression has errors than.

[disqr_rm]

You can see I forgot to close the square bracket. So it should have been: if(count([email address]) > 1, 1)

It's always best to use square brackets around fields if your field has a space or any special characters. Or if your fieldname is conflicting with an internal QV keyword or function (like date or time) you sould use square brackets as well.

[#5]

Thanks again Rakesh!

[amars]

An alternative way is to create a ListBox & make the Show Frequency Checkbox Checked in the General Properties & in the Sort check the Frequency checkbox.

Regard's

Amar

[#7]

That's correct Amar. I experimented with that also.

Tnx.