topic Re: Highlight Duplicates in QlikView

Highlight Duplicates

Frank_Hartmann — Sat, 16 Nov 2024 04:44:33 GMT

Anyone able to tell me how to highlight the duplicates in Row 56 and 57

and also in Row 75 and 76?

Thx in advance

EDIT: I scrambled the GS Number field, so the rows might change!

Re: Highlight Duplicates

sunny_talwar — Wed, 16 Jan 2019 14:58:10 GMT

I am not sure why do you consider them with having duplicates... when I select Row 79's GS_Nummer (IB4989691)... I see only 1 row. Same is true when I select Row 80's GS_Nummer

Re: Highlight Duplicates

Frank_Hartmann — Wed, 16 Jan 2019 15:05:05 GMT

hi sunny,

was my mistake.

please look at this pic:

Re: Highlight Duplicates

sunny_talwar — Wed, 16 Jan 2019 15:06:31 GMT

Okay those make sense, but they are not 79 & 80 or 150 & 151 which is what confused me. Going back to your question, what would you like to highlight? Dimension or expression or both?

Re: Highlight Duplicates

Frank_Hartmann — Wed, 16 Jan 2019 15:08:45 GMT

only the dimension!

Re: Highlight Duplicates

sunny_talwar — Wed, 16 Jan 2019 15:13:37 GMT

Try this

=Aggr(NODISTINCT If(Count({$<WeekDiff={'>$(vZeitraum5KW)<=$(vZeitraum4KW)'}>} GS_Nummer) > 1, LightGray()), GS_Nummer)

Re: Highlight Duplicates

Frank_Hartmann — Wed, 16 Jan 2019 15:37:20 GMT

Thank you very much, Sunny 🙂

Re: Highlight Duplicates

davyqliks — Thu, 06 Feb 2020 15:49:03 GMT

Hi Sunny,

I am looking to find duplication based on 2 dimensions.

I have assigned an invoice item line number to each invoice no and need to be sure that there is no duplication. of those 2 values.

i tried like this in a text box

='Number of Duplicates = ' & Sum(Aggr(If(Count([Invoice no.])>1,1,0),[Invoice item line number]))

but this returns some duplication, when i check those Invoice no. each line has a unique Invoice item line number

Can you share how to check if duplicates exist using 2 dimensions as the unique value?

Thanks

Daniel

Re: Highlight Duplicates

sunny_talwar — Thu, 06 Feb 2020 15:52:10 GMT

May be you need to check Distinct Count

Sum(Aggr(If(Count(DISTINCT [Invoice no.]) > 1, 1, 0), [Invoice item line number]))

Re: Highlight Duplicates

davyqliks — Thu, 06 Feb 2020 16:46:19 GMT

Many thanks for the reply,

when i add that, the expression just appears in the box,

i did add Distinct to my example:

='Number of Duplicates = ' & Sum(Aggr(If(Count(DISTINCT[Invoice no.])>1,1,0),[Invoice item line number]))

but the return is the same.

Can you confirm the above is checking duplication using 2 dimensions as a unique key?

Thank you Sunny

Re: Highlight Duplicates

sunny_talwar — Thu, 06 Feb 2020 16:55:17 GMT

This is just checking if [Invoice item line number] has two or more [Invoice no.]

Re: Highlight Duplicates

davyqliks — Fri, 07 Feb 2020 14:53:25 GMT

Thank you so much,

seems i need to swap the values round 🙂

Much appreciated Sunny.

Regards,

Daniel

Re: Highlight Duplicates

sunny_talwar — Fri, 07 Feb 2020 15:10:02 GMT

Awesome!!