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: 
ramcena306
Creator II
Creator II

How does one check for duplicate entries in a field

how does one check for duplicate entries in a field , and identify maximum value with duplicate entries?

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

Another way via front,

Capture.JPG

View solution in original post

4 Replies
sunny_talwar

May be create a straight table like this

Dimension

FieldName

Expression

Count(FieldName)

jonathandienst
Partner - Champion III
Partner - Champion III

Or in a textbox:

=Max(Aggr(Count(FieldName), FieldName))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
omkarvamsi
Creator
Creator

show that field in listbox and check frequency option and also select frequency option under sort tab of list box properties(ascending/descending).it shows the count of repetitions of the field records.

devarasu07
Master II
Master II

Hi,

Another way via front,

Capture.JPG