4 Replies Latest reply: Jun 29, 2012 2:57 PM by udayshankark RSS

    SQL case eqvuivalent in qlikview

      I have an case statement(working) in sql server. I have to write the same in qlik view. So, I used if statement for that, but it says there is an error.

      It does not give the exact error, is there a way to debug this ??

       

      case when isnull(count(y), 0) > 0 then  sum(x)/count(y) else 0 end

       

      For this the if statement i am using is

      if ( isnull(count(y),0) > 0 , sum(x)/count(y) , 0)