topic Re: Find duplicate records in QlikView

Find duplicate records

Sun, 13 Jan 2013 07:41:48 GMT

Hi,

How to find duplicate records from given below tables:

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

Result is 2, kindy gives suggestion to resolve it.

Regards,

Zain.

Re: Find duplicate records

SunilChauhan — Sun, 13 Jan 2013 08:27:35 GMT

in dimension

OrderNumber and city Name

and in expression

Count(OrderNumber )-count(distinct OrderNumber )

hope this helps

Re: Find duplicate records

Sun, 13 Jan 2013 08:38:24 GMT

I tried but its show me count result 4.

Regards,

Zain.

Re: Find duplicate records

SunilChauhan — Sun, 13 Jan 2013 08:45:54 GMT

see the attached file

hope this helps

Re: Find duplicate records

Sun, 13 Jan 2013 09:25:13 GMT

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.

Re: Find duplicate records

nagaiank — Sun, 13 Jan 2013 10:28:39 GMT

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

Re: Find duplicate records

Sun, 13 Jan 2013 12:23:41 GMT

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

Regards,

Zain.

Re: Find duplicate records

nagaiank — Sun, 13 Jan 2013 13:00:09 GMT

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))

Re: Find duplicate records

Sun, 13 Jan 2013 13:18:49 GMT

Thanks a lot its working now.

Regards,

Zain.