Count of duplicate records

[mansoorsheraz]

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.

[mansoorsheraz · Accepted solution]

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...