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

Sumif equivalent

Hi,

I know it might have been asked several times but I'm struggling to find an answer.

I'm trying to translate this into a formula:

Column A contains multiple groups (Group A, Group B, Group C)

Column B contains numeric data (figures in EUR)

Column C contains time data (a certain number of hours)

I'm trying to have a formula that says:

sum of column B for Group A / sum of column C for Group A

How would it translate into a formula?

Thank you for your help!!

1 Reply
swuehl
MVP
MVP

Either using something like

=Sum( If( ColumnA = 'Group A', ColumnB))

or using set analysis:

=Sum({<ColumnA  = {'Group A'}>} ColumnB)

Similar to get the filtered sum for ColumnC.