Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
mansoorsheraz
Contributor III
Contributor III

Count of duplicate records

Hi,

We have a small issue which needs community help. We want to count the number of duplicate records in a table and need to display it separately in a table.

E.g.

Project   WorkWeek2     WorkWeek3
A                 John                  Alan
B                 John                  Tom
C                 Tom                   Alan
D                 Roy                    John
E                 Tom                   Alan

Resultant Table

Worker        CountWorkWeek2       CountWorkWeek3
John                  2                                         1
Alan                   0                                          3
Tom                   2                                         1
Roy                    1                                          0

Looking for help if this can be achieved in Qlik

Regards.

 

 

Labels (4)
1 Solution

Accepted Solutions
mansoorsheraz
Contributor III
Contributor III
Author

Hi Guys,

Figured it out:

=Count(If(Worker = [WorkWeek2], [WorkWeek2]))

Thanks to the help available here :
https://community.qlik.com/t5/QlikView-App-Dev/Lookup-if-found-then-how-many-times-it-s-found-in-non...

View solution in original post

1 Reply
mansoorsheraz
Contributor III
Contributor III
Author

Hi Guys,

Figured it out:

=Count(If(Worker = [WorkWeek2], [WorkWeek2]))

Thanks to the help available here :
https://community.qlik.com/t5/QlikView-App-Dev/Lookup-if-found-then-how-many-times-it-s-found-in-non...

View solution in original post