topic Set analysis Problem-Where to add in extra set analysis in QlikView

Set analysis Problem-Where to add in extra set analysis

helen_pip — Mon, 03 Dec 2012 11:46:02 GMT

Hello,

Could someone kindly help me write some set analysis. The below syntax works and is near to what I want to achieve, but I want to add some extra syntax in

I want to add where

This Works

=Time(RangeFractile(.95, $(=Concat([Total Wait], ',') & ',' & Concat(CONCLUSION_WAIT_MINS, ','))

This does not work

=Time(RangeFractile(.95, $(=Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >}[Total Wait], ',') & ',' & Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>}CONCLUSION_WAIT_MINS, ',')))/1440,'hh:mm')

I have added in the following

[Patient Admitted?]={"1"} >} in front of [Total Wait] and [ADMISSION_FLAG]={"Y"}>} in front of CONCLUSION_WAIT_MINS, but the syntax returns a Null value

Can someone kindly help me put the right brackets in the right place to incorporate both [Patient Admitted?]={"1"} >} and [ADMISSION_FLAG]={"Y"}>}

Thanks

Helen

Re: Set analysis Problem-Where to add in extra set analysis

fosuzuki — Mon, 03 Dec 2012 19:14:12 GMT

Hi Helen,

Your expression looks like it's ok...

You should try to break down the parts to debug it. So, what are the return values of the below expressions?

- Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >} [Total Wait], ',')

- Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>} CONCLUSION_WAIT_MINS, ',')

Re: Set analysis Problem-Where to add in extra set analysis

helen_pip — Tue, 04 Dec 2012 09:03:29 GMT

Hello Fernando,

Thank you for your reply. I will try debugging

Concat({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"1"} >} [Total Wait], ',') will return 02:03

and

Concat({<RunMonthEye = {$(=Max(RunMonthEye))}, [ADMISSION_FLAG]={"Y"}>} CONCLUSION_WAIT_MINS, ',') will return a null value

Thanks

Helen