topic Re: Expressions query in QlikView

Expressions query

Fri, 30 Nov 2012 14:01:18 GMT

I have the script below which provides me with:

a sum of costs for Acute within the Quadrant field and
a sum of costs for In Patients etc... within the Quadrant Sub category, where the Quadrant is Mental Health

=money(Sum({1<Quadrant={"Acute"}>+1<Quadrant={"Mental Health"}, [Quadrant Sub category]=
{"In Patients","Day Care", "Out Patients Procedures", "Outpatients East", "Outpatients West"}>} [Cost £]))

I'm looking to develop this, to say the above, but when the field "Episodes" is not blank

I would appreciate your advice on this

Many thanks

Claire

Re: Expressions query

Gysbert_Wassenaar — Fri, 30 Nov 2012 17:36:42 GMT

Is this what you need?

=money(Sum({1<Quadrant={"Acute"},Episodes={"=len(trim(Episodes))>0"}>+1<Quadrant={"Mental Health"},Episodes={"=len(trim(Episodes))>0"}, [Quadrant Sub category]=
{"In Patients","Day Care", "Out Patients Procedures", "Outpatients East", "Outpatients West"}>} [Cost £]))

Re: Expressions query

Tue, 04 Dec 2012 14:21:17 GMT

Thank you, worked perfectly!