Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find duplicate records

Hi,

How to find duplicate records from given below tables:

order_numbercity_name
10000004rüsselsheim
10000008kiel
10000009schildow
10000011mühlenbach
10000012brandenburg
10000013schildow
10000014schildow
10000004rüsselsheim
10000008kiel
10000008kiel
10000008kiel

Result is 2, kindy gives suggestion to resolve it.

Regards,

Zain.

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Use the following expression in a text box and see if this meets your requirements.

='Number of Dupplicates = ' & Sum(Aggr(If(Count(city_name)>1,1,0),order_number))

View solution in original post

8 Replies
TigerisBack
Champion
Champion

in dimension

OrderNumber and city Name

and in expression

Count(OrderNumber )-count(distinct OrderNumber )

hope this helps

Not applicable
Author

I tried but its show me count result 4.

Regards,

Zain.

TigerisBack
Champion
Champion

see the attached file

hope this helps

Not applicable
Author

Thanks for reply, but my problem still same, i need count just dislay 2 not with dimension, second i used your condition but its show me some result is true and some result is false i dont know why, i will send you application, right now if(count(OH.order_number)>1,count(OH.order_number)) this expression is ok to me.

its gave me correct result but i unable to show total count in  text object.

Regards

Zain.

nagaiank
Specialist III
Specialist III

A sample application showing the two duplicate order_numbers for your data is attached. Hope this helps.

Not applicable
Author

Thanks for your replay, i need expression show me result without any changes in script, i did and got result in script.

Regards,

Zain.

nagaiank
Specialist III
Specialist III

Use the following expression in a text box and see if this meets your requirements.

='Number of Dupplicates = ' & Sum(Aggr(If(Count(city_name)>1,1,0),order_number))

View solution in original post

Not applicable
Author

Thanks a lot its working now.

Regards,

Zain.