Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)