Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
slpalmgren
Contributor
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
Specialist II
Specialist II

Please share a sample app/dataset with the expected output

sergio0592
Specialist III
Specialist III

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)