Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rakesh_kumar
Contributor

Expressions to get values derived from chart into Text boxes?

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

1 Solution

Accepted Solutions

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

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

View solution in original post

2 Replies

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

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

View solution in original post

rakesh_kumar
Contributor

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

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