Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Experts,
In the attached application my objective it to fill the text boxes with the value derived from the chart. I have documented my requirements in the text boxes it self. I am looking for an expression that will go into those text boxes to get the desired results like the ones shown in the chart for "Monday".
So please can someone help with me with the expressions for both the "Admissions / Attendances" and "Discharges / Admissions" text boxes?
Thanks,
RK
This does the first one, I am sure you can work out the rest using this as an example.
=Num (
Count({<
AdmissionDateTime={">=$(=weekstart(max(Date_Field),-1)) <=$(=weekend(max(Date_Field),-1)+1)"},
AdmissionMethodCode = {21} ,
Calendar_Weekday={"Mon"}
>}LocalPatientIdentifier)
/
Count({<
Arrival_Date_Time={">=$(=weekstart(max(Date_Field),-1)) <=$(=weekend(max(Date_Field),-1)+1)"} ,
Calendar_Weekday={"Mon"}
>}AE_Number)
,'#,##0.00%')
This does the first one, I am sure you can work out the rest using this as an example.
=Num (
Count({<
AdmissionDateTime={">=$(=weekstart(max(Date_Field),-1)) <=$(=weekend(max(Date_Field),-1)+1)"},
AdmissionMethodCode = {21} ,
Calendar_Weekday={"Mon"}
>}LocalPatientIdentifier)
/
Count({<
Arrival_Date_Time={">=$(=weekstart(max(Date_Field),-1)) <=$(=weekend(max(Date_Field),-1)+1)"} ,
Calendar_Weekday={"Mon"}
>}AE_Number)
,'#,##0.00%')
Thanks Bill for the quick reply, this is what I am looking for. Thanks a lot for your help