Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Hartmann
Master II
Master II

Highlight Duplicates

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!

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

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

image.png

View solution in original post

12 Replies
sunny_talwar

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

Frank_Hartmann
Master II
Master II
Author

hi sunny,

 was my mistake.

please look at this pic:

Unbenannt.png

sunny_talwar

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?

Frank_Hartmann
Master II
Master II
Author

only the dimension!
sunny_talwar

Try this

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

image.png

Frank_Hartmann
Master II
Master II
Author

Thank you very much, Sunny 🙂
davyqliks
Specialist
Specialist

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

 

sunny_talwar

May be you need to check Distinct Count

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

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