topic Re: text object show the max date for current wait in QlikView

text object show the max date for current wait

qliklizzy — Mon, 29 Jan 2018 15:19:44 GMT

I have a cohort of people showing the time they came in and their associated EDwait

I have a text box that shows the number of these patient's waiting

=count({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EventUniqueID)

the other box I need to show what the last persons wait was.. so I need a max of date but show the EDwait if you like ?

I tried this:

=Interval(max({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)/24/60, 'hh:mm')

but this just gives me the max EDwait for all of those people. I cant figure out how to add in the max date

thanks

Re: text object show the max date for current wait

Anil_Babu_Samineni — Tue, 30 Jan 2018 00:37:40 GMT

What this returns when you use below one?

max({<MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 09:40:30 GMT

this just shows the max value of EDready wait.

So if there was 10 people who are ED ready it shows the longest wait,

however I need to refine it to the last person who came in , so max date and bring back their EDready wait

thanks

Re: text object show the max date for current wait

tresB — Tue, 30 Jan 2018 09:45:15 GMT

Try using FirstSortedValue(), like:

=FisrtSortedValue({Set analysis} PatientField , -EDreadyWait)

Re: text object show the max date for current wait

jonathandienst — Tue, 30 Jan 2018 09:45:56 GMT

How do you identify the last person who came in (ie which field and what does the field contain)?

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 09:49:40 GMT

assessmentdatetime is the time they came in,

I need a max of this, on the set analysis, bringing back the edready wait

thanks

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 09:53:19 GMT

thanks

this doesn't work.. I get a big number..

do you mean paitentfield is the date I need the max applying to?

=FirstSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} AssessmentDateTime , -EDReadyWait)

Re: text object show the max date for current wait

tresB — Tue, 30 Jan 2018 09:57:30 GMT

May be this?

=FisrtSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} PersonField , -assessmentdatetime)

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 09:58:14 GMT

sorry was is person field?

thanks

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 10:01:30 GMT

sorry I edited my first reply to you, as I had first spelt incorrectly.

it returns a big value, where I need it to display time.

so I applied interval to it but it still doesn't retrieve the right answer.

the last person in should be 00:18 but I get 718:49

=interval(FirstSortedValue({<MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''} >} AssessmentDateTime , -EDReadyWait)/24/60, 'hh:mm')

Re: text object show the max date for current wait

jonathandienst — Tue, 30 Jan 2018 10:02:32 GMT

Give this one a shot:

FirstSortedValue({<

EventUniqueID = P({<

MetricDesc=,

MetricID={'LI01'},

Status-={'DISCHARGED','COMPLETED','LETTER'},

Location-={'EAU'},

ReadyStatus -={''}>

} EventUniqueID)

>} EDReadyWait, -assessmentdatetime)

Wrap this expression in an interval function if required

Re: text object show the max date for current wait

tresB — Tue, 30 Jan 2018 10:05:59 GMT

I should have read your first post a bit more carefully. Try like:

=Interval(max({<EventUniqueID ={"=assessmentdatetime=Max(TOTAL assessmentdatetime)"}, MetricDesc=,MetricID={'LI01'},Status-={'DISCHARGED','COMPLETED','LETTER'}, Location-={'EAU'}, ReadyStatus -={''}>} EDReadyWait)/24/60, 'hh:mm')

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 10:07:38 GMT

Thank you! so much

I don't understand it - no way could I have figured that out!

thank you again

Liz x

Re: text object show the max date for current wait

qliklizzy — Tue, 30 Jan 2018 10:11:03 GMT

its just returning -

thank you for you help, really appreciate it, Jonathon's reply has fixed the issue, you were on the right lines with firstsortedvalue

Re: text object show the max date for current wait

jonathandienst — Wed, 31 Jan 2018 11:18:39 GMT

I assume you are unsure about this bit:

EventUniqueID = P({<

MetricDesc=,

MetricID={'LI01'},

Status-={'DISCHARGED','COMPLETED','LETTER'},

Location-={'EAU'},

ReadyStatus -={''}>

} EventUniqueID)

This set expression just selects the EventUniqueID values that fit with the selection criteria in your post. P() is possible values.

Re: text object show the max date for current wait

qliklizzy — Wed, 31 Jan 2018 12:17:59 GMT

arh thanks brilliant,

and the first sort value gives me the latest assessment date on that set expression

good to know! thanks

I have used this twice now already, very handy!