topic Re: Selection filter for Fire Department data in QlikView

Selection filter for Fire Department data

bradcusick — Wed, 09 May 2018 15:23:20 GMT

Fire Department Data Analysis

Hello,

I want to create a filter (as a button? or multi box?) that will display incidents that meet a certain criteria. The criteria is at least 4 suppression apparatus arrive on scene. I have an existing expression that ranks the arrival order of suppression apparatus (1, 2, 3, 4 etc.). My thoughts are to create a filter that will displays incidents that have a suppression apparatus arrival order sum of >=10 ( this would mean that 1,2,3 and 4 arrived on scene. 1+2+3+4=10)

I've tried to make a Multi box for this but it does not work. Any ideas?

Here is my starting expression: =if(Sum([Scene Arrival Order (Pump Heavy Apparatus)]>='10'),'Yes')

Re: Selection filter for Fire Department data

sunny_talwar — Wed, 09 May 2018 16:41:37 GMT

May be try this with Aggr() function

Aggr(If(Sum([Scene Arrival Order (Pump Heavy Apparatus)] >= 10), 'Yes'), Incident)

Re: Selection filter for Fire Department data

bradcusick — Wed, 09 May 2018 17:04:46 GMT

That at least creates a valid expression that brings back data. It is not selecting what I would expect however. I am aggregating by Incident Number but that is bring back very few incidents - less than what it should be.

Re: Selection filter for Fire Department data

sunny_talwar — Wed, 09 May 2018 17:14:37 GMT

My bad, try this

Aggr(If(Sum([Scene Arrival Order (Pump Heavy Apparatus)]) >= 10, 'Yes'), Incident)

Re: Selection filter for Fire Department data

bradcusick — Wed, 09 May 2018 17:27:21 GMT

Perfect! Thank you so much.