Discussion board where members can get started with QlikView.
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?
Go to Solution.
I hope the attach applicatioon is what you are looking for.
I believe you just add DISTINCT to your script.
From your example:
LOAD DISTINCT Clinic_Code,
(ooxml, embedded labels, table is Sheet1);
Please find the attachment for solution.