3 Replies Latest reply: Jan 9, 2017 12:31 PM by denis Brennan RSS

    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