How to get the sum of ColumnB values for all the ColumnA values starting with 'AA'

[Sony]

I'm new to QlikSense and I have been struggling to find the solution to my problem. I have 2 columns in my table- ColumnA & ColumnB as shown below

ColumnA | Column B

ABC | 1

AABC | 4

ABBC | 2

ABCC | 2

AABB | 1

I want to get the sum of ColumnB for all the ColumnA values starting with'AA'. The output should be 5.

Please help me!

[henrikalmen · Accepted solution]

It can be done with set analysis: sum({<[ColumnA]={"AA*"}>} [ColumnB])

Or you could do sum(if(ColumnA like 'AA*', ColumnB, 0))

[ogster1974 · Accepted solution]

This will work.