How to get the sum of a field with one certain value selected from another field in a text object

[Anonymous]

I'm very new to QlikView with not much experience in this type of stuff so this might be a simple question or difficult not sure....

I'm trying to get the sum of the ActualHours field only from 'Planned Maintenance' in the Purpose field, and place the expression into a text box. Is this possible?

'Purpose' Field:

Purpose
On-Call
Planned Maintenance
Unscheduled (Reactive) Maint.

'ActualHours' Field:

ActualHours
5
80.5
14
3.5
etc....

Any help would be greatly appreciated.

Thanks,

Korrie

[Anonymous · Accepted solution]

Hi

You can try like this

sum (  { <  Purpose={"Planned Maintenance"} >  }        ActualHours  )

[Anonymous]

Yes, that worked and was what I needed. Thank you very much!