Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
slpalmgren
New Contributor

<= after set analysis for Fire Department

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'}>}

2 Replies
techvarun
Valued Contributor II

Re: <= after set analysis for Fire Department

Please share a sample app/dataset with the expected output

sergio0592
Valued Contributor II

Re: <= after set analysis for Fire Department

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)