7 Replies Latest reply: Mar 11, 2013 5:58 AM by cwdeveloper RSS

    Problem with if sum

      I all

      i'm new of qlik if someone help me pleas

      I would like have a total amount with  condition

       

       

      Example

      Month, Budget, Sales

      Gen,100.25

      Feb,100,25,

      Mar,100,0

      Apr,100,0

      etc

       

      The total that i would like obtain is 250.

       

      I used the follow expression but the total that i obtain is 400   or 50

       

       

      if (sum(Sales)>0,sum(Sales), sum(Budget) )

       

       

       

      Many thanks

      PT