Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi

You can try like this

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi

You can try like this

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

Anonymous
Not applicable
Author

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