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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use distinct?

I have columns for clinicname, attendanceid and date and am trying to get average number of attendances per clinic.

How do I use distinct to get 1 as value for clinic name per date and a count of attendances?

Thanks


Ian

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

Hi,

I hope the attach applicatioon is what you are looking for.

Deepak

View solution in original post

3 Replies
Not applicable
Author

I believe you just add DISTINCT to your script.

From your example:

LOAD DISTINCT Clinic_Code,

     attendanceid,

     date

FROM

(ooxml, embedded labels, table is Sheet1);

deepakk
Partner - Specialist III
Partner - Specialist III

Hi,

I hope the attach applicatioon is what you are looking for.

Deepak

jagan
Partner - Champion III
Partner - Champion III

Hi,

Please find the attachment for solution.

Regards,

Jagan.