Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Can I use distinct?

Hi,

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

Deepak

3 Replies
Not applicable

Can I use distinct?

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
Not applicable

Re: Can I use distinct?

Hi,

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

Deepak

jagan
Not applicable

Re: Can I use distinct?

Hi,

Please find the attachment for solution.

Regards,

Jagan.