This content has been marked as final. Show 4 replies
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)