Conditional Logic in Qlik Sense

[#1]

Hi all,

I'm struggling with conditional logic that won't seem to work.

I have a field Value and I want to calculate the sum of teh field based upon a value in another field Category.

I have tried IF logic like this "if( Category= 'Income', (sum(Value) ))"

I have tried Set analysis like this "=Sum({$<Category={$(="Income")}>}Value)"

Neither works. Here is a screenshot of a table showing that there are data in both fields.

I hope someone can help me - I'm sure it's something really basic.

Many thanks in advance

[Aurelien_Martinez]

Hi,

Try :

Sum({<Category={'Income'}>} Value)

Aurélien

[sunny_talwar · Accepted solution]

Try this:

=Sum({$<Category={'Income'}>}Value)

[#4]

Many thanks to you both. Sunny's answer worked immediately.