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

    Conditional Logic in Qlik Sense

    denis Brennan

      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