topic Show duplicate table values in QlikView

Show duplicate table values

Fri, 24 Jul 2009 21:12:32 GMT

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.

Show duplicate table values

disqr_rm — Fri, 24 Jul 2009 22:07:05 GMT

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.

Show duplicate table values

Mon, 27 Jul 2009 16:09:26 GMT

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.

Show duplicate table values

disqr_rm — Mon, 27 Jul 2009 23:10:17 GMT

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.

Show duplicate table values

Tue, 28 Jul 2009 13:46:19 GMT

Thanks again Rakesh!

Show duplicate table values

amars — Tue, 28 Jul 2009 20:20:20 GMT

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

Show duplicate table values

Wed, 05 Aug 2009 16:21:01 GMT

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

Tnx.