topic Re: Can I use distinct? in QlikView

Can I use distinct?

Fri, 02 Mar 2012 17:34:05 GMT

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

Fri, 02 Mar 2012 17:40:14 GMT

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 — Fri, 02 Mar 2012 19:59:04 GMT

Hi,

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

Deepak

jagan — Mon, 05 Mar 2012 06:12:33 GMT

Hi,

Please find the attachment for solution.

Regards,

Jagan.