Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to detect duplicate?

Employee                Status                         StatusId

Alex                         Submit                             A1

Alex                         Submit                              A2

Alice                         In progress                        B1

Jack                         Submit                              C1

Jack                         In progress                        C2

What formula should i use,I want to show If employee has more than one status then it is duplicate and show the duplicate id.

The result should be:

Employee   Status                          Duplicate ID

Alex           Duplicate                         A1,A2

Jack           Duplicate                         C1,C2

TQ

Labels (1)
10 Replies
Anonymous
Not applicable
Author

Tq Jagan Mohan