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

[#2]

Hi Vikas,

  Can you can tell,Where I have to write this '= Sum(Aggr(If(Count(emp num)>1,1,0),empnumname,emp name))'

expression, in Straight Table.

Regards,

Sreenadha P

[Kushal_Chawda]

In your case it is not relevant as expression will do the job

[Anonymous]

oh ok I was going the other way round, I used the expression as simple count(emp num) and then thought of only doing conditional enable for duplicate records

[Kushal_Chawda]

Either way you need to write the expression , so why to complicate the things, just use single expression that's it

[Anonymous]

thank you all

[Kushal_Chawda]

Please mark the correct and helpful answers to help other if they came across same problem

[florentina_doga]

try this expression in chart

if(Count(empnum)<>1,empnum &' - '& Count(empnum))