Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Find Duplicate Dates for One Client

Hello, 

I have a table with ClientID and ContactDate

I am trying to find all of the ClientIDs that have more than one contact on the same date 

Is this possible? 

Thank you 

Labels (2)
3 Replies
Taoufiq_Zarra

if i understood correctly, one solution in the load script :

Data:
LOAD * INLINE [
    ClientID , contact, ContactDate
    1, c1, 01/01/2020
    1, c2, 01/01/2020
    3, c3, 01/01/2020
];

Group:
load ClientID,ContactDate,CountContact where CountContact>1;
load ClientID,ContactDate,count(contact) as CountContact resident Data group by ClientID,ContactDate;

drop table Data;

 

the output : the ClientIDs that have more than one contact on the same date

Capture.PNG

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Taylorcc
Contributor III
Contributor III
Author

Thank you - that output is exactly what I am after 

 

I loaded the script and created a table but the CountContact field is only showing '-'

 

 

 

Taoufiq_Zarra

can you share the script ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉