show duplicate records

[Anonymous]

Hi,

I have this straight table in QV, but I need it to show only the employees with duplicate emp num, in this case only both the rows of emp num 12, I tried using conditional enable but it doesn't work. please advise

Thanks

empnumname	emp num	emp name
11john smith	11	john smith
12lynne	12	lynne
12sunny	12	sunny
22mike pepper	22	mike pepper

[vikasmahajan]

Try this

= Sum(Aggr(If(Count(emp num)>1,1,0),empnumname,emp name))

[Kushal_Chawda]

your straight table expression should look like below

= sum({<[emp name]={"=count([emp num]>1)"}>} Value)

[sunny_talwar · Accepted solution]

I would use empnumname instead of emp name because emp name can repeat. and you missed a closing parenthesis at the end of count

=Sum({<empnumname={"=Count(empnumname)>1"}>} Value)

[tamilarasu]

Sunny,

Try like below,

=If(aggr(NODISTINCT count([emp num]),[emp num])>1,[emp name])

[sunny_talwar]

I didn't see that OPs name was Sunny too. I was like why me

[tamilarasu]

[Anonymous]

Thanks guys, that helps, I was just wondering why can't we adopt a more simpler way like conditional enabling or calculation where count of emp num > 1

[Kushal_Chawda]

But why you need conditional enabling here?

[Anonymous]

to show only duplicate records