Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Conditional Logic in Qlik Sense

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

Screen Shot 2017-01-09 at 16.17.11.png

1 Solution

Accepted Solutions

Re: Conditional Logic in Qlik Sense

Try this:

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

3 Replies
amartinez35
Valued Contributor

Re: Conditional Logic in Qlik Sense

Hi,

Try :

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

Aurélien

Re: Conditional Logic in Qlik Sense

Try this:

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

Not applicable

Re: Conditional Logic in Qlik Sense

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