Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to sum two field

code type    detail                hourspent

a                      big                 10

a                       small             14

b                       big                11

c                       big                12

d                       medium         12

e                       big                 11

a                         big                 21

What formula to use to sum only for code type=a &detail=big?

1 Reply
Not applicable
Author

=sum({<codetype = {'a'}, detail = {'big'}>} hourspent)