topic Re: <= after set analysis for Fire Department in QlikView

<= after set analysis for Fire Department

slpalmgren — Wed, 25 Nov 2020 16:16:04 GMT

We are trying to create an expression that shows the % of time a call is <=300 seconds. This is what we have tried but it is not working for some reason. Anyone have any suggestions?

=Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} (time_arrivedatscene-time_enroute) <= '0:05:00')

/Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} (time_arrivedatscene-time_enroute))

//[Travel (secs)]={'<=300'}>}

Re: <= after set analysis for Fire Department

techvarun — Tue, 13 Aug 2019 06:41:20 GMT

Please share a sample app/dataset with the expected output

Re: <= after set analysis for Fire Department

sergio0592 — Tue, 13 Aug 2019 07:08:35 GMT

Hi,

What is your key for your call table? Suppose it's ID_Call. Try to pre calculate in your load statement in order to get the field with the call lenght :

time_arrivedatscene-time_enroute

And try:

Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'}, [division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}, call_lenght={"<=300"}>} ID_Call) / Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'}, [division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} ID_Call)