topic Re: Expressions to get values derived from chart into Text boxes? in QlikView

Expressions to get values derived from chart into Text boxes?

rakesh_kumar — Tue, 19 May 2015 12:42:57 GMT

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,

Re: Expressions to get values derived from chart into Text boxes?

Anonymous — Tue, 19 May 2015 12:52:06 GMT

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%')

Re: Expressions to get values derived from chart into Text boxes?

rakesh_kumar — Tue, 19 May 2015 14:04:26 GMT

Thanks Bill for the quick reply, this is what I am looking for. Thanks a lot for your help