topic Re: show duplicate records in QlikView

show duplicate records

Anonymous — Fri, 29 Apr 2016 07:00:22 GMT

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

Re: show duplicate records

vikasmahajan — Fri, 29 Apr 2016 07:05:00 GMT

Try this

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

Re: show duplicate records

Kushal_Chawda — Fri, 29 Apr 2016 07:09:46 GMT

your straight table expression should look like below

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

Re: show duplicate records

sunny_talwar — Fri, 29 Apr 2016 07:14:59 GMT

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)

Re: show duplicate records

tamilarasu — Fri, 29 Apr 2016 07:15:49 GMT

Sunny,

Try like below,

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

Re: show duplicate records

sunny_talwar — Fri, 29 Apr 2016 07:17:15 GMT

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

Re: show duplicate records

tamilarasu — Fri, 29 Apr 2016 07:18:31 GMT

Re: show duplicate records

Anonymous — Fri, 29 Apr 2016 07:55:57 GMT

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

Re: show duplicate records

Kushal_Chawda — Fri, 29 Apr 2016 08:07:07 GMT

But why you need conditional enabling here?

Re: show duplicate records

Anonymous — Fri, 29 Apr 2016 08:13:09 GMT

to show only duplicate records

Re: show duplicate records

Fri, 29 Apr 2016 08:27:05 GMT

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

Re: show duplicate records

Kushal_Chawda — Fri, 29 Apr 2016 08:31:19 GMT

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

Re: show duplicate records

Anonymous — Fri, 29 Apr 2016 08:42:00 GMT

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

Re: show duplicate records

Kushal_Chawda — Fri, 29 Apr 2016 08:46:13 GMT

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

Re: show duplicate records

Anonymous — Fri, 29 Apr 2016 09:27:01 GMT

thank you all

Re: show duplicate records

Kushal_Chawda — Fri, 29 Apr 2016 09:31:16 GMT

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

Re: show duplicate records

florentina_doga — Fri, 29 Apr 2016 13:49:46 GMT

try this expression in chart

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