topic Re: Percentage By Dimension & Set Analysis in QlikView

Percentage By Dimension & Set Analysis

Anonymous — Wed, 24 Dec 2014 08:39:21 GMT

I am trying to show a percentage by dimension. for all patient appointments. This works using the following :

(

Count(patient_id)) / (Count(TOTAL <appointment_month> patient_id))

The issue I have is that I only want to include any records which have a AppointmentReason = 'Health'

How do I update the expression to include the set analysis also?

Regards

Phil

Gysbert_Wassenaar — Wed, 24 Dec 2014 08:41:25 GMT

Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)

Anonymous — Wed, 24 Dec 2014 08:56:13 GMT

Hi try like this

If Condition

=Count(distinct If(AppointmentReason = 'Health',Patient_Id)) / Count(Total If(MonthName = appointment_month,Patient_Id))

Set Analysis:

Count({<AppointmentReason = {'Health'}>}patient_id) / Count({<AppointmentReason = {'Health'}>}TOTAL <appointment_month> patient_id)

Anonymous — Wed, 24 Dec 2014 09:00:17 GMT

Worked a treat. Thanks