Sum of unique values

[Lau256]

Hi,

I am new to Qliksense- as you can probably tell by my question!

I have a field called Clinic slots available and am wanting to do a sum of these only where the fields Appointment date and clinic code are unique.

Any help would really be appreciated.

Many thanks 🙂

[PrashantSangle]

post sample data with required result

[Lau256]

Clinic Code

Appointment Date

Week Commencing

Month

Forward / Historic Look

Clinic Slots Available

Booking Units Free.

Clinic Slots Booked

Attendance Count

DNAs

OTD Patient Cancellations

Patient cancellation prior to Appt date

Total patient Cancellations

Hospital Cencellation count

OTD Hospital Cancellations

Hospital Cencellation count under 6 weeks

Attendances + DNAs (Past) / Appointments Booked (future)

BSU Target Income (Slots Available * Tariff * 95%)

Financial Opportunity if booked at 95%

Vacant slots?

OTD Patient canxellations + Activity

Value of slots OTD pt canx

First Attendance Indicator

Virtual Appt count

Telephone Appt count

Webcam appt count

Telephone Attendance count

Webcam Attendance count

Virtual Attendance count

Face to Face apppointment count

Face to Face Attendance count

APB1AF

15/06/2020

15/06/2020

30/06/2020

Historic Look

14

0

14

3

2

1

1

10

10

5

£0.00

-£123

Clinic Fully Booked

3

351.9236534

Follow up attendance face to face

16

3

APB1AF

15/06/2020

15/06/2020

30/06/2020

Historic Look

14

0

14

8

1

9

£0.00

-£123

Clinic Fully Booked

8

175.9618267

Follow up telephone or telemedicine consultation

9

8

[Lau256]

As you can see from the above, there are two entries for the Clinic on that particular day due to the first attendance indicator- however, the Clinic slots available should only be counted once- at 14 not 28