topic Re: SQL case eqvuivalent in qlikview in QlikView

SQL case eqvuivalent in qlikview

Fri, 29 Jun 2012 17:45:50 GMT

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)

Re: SQL case eqvuivalent in qlikview

nagaiank — Fri, 29 Jun 2012 18:23:51 GMT

Try the following expression instead:

If( IsNull(Count(y)) or Count(y)=0, 0, Sum(x)/Count(y)) as your-field-name

Re: SQL case eqvuivalent in qlikview

Fri, 29 Jun 2012 18:45:27 GMT

Yeah looks like it works with both.

Can you please explain, what was wrong with my code(other than the isnull syntax), and how is your code different from mine.

Why does it not work for positive condition?

Re: SQL case eqvuivalent in qlikview

nagaiank — Fri, 29 Jun 2012 18:55:39 GMT

IsNull(expr) Qlikview function Returns -1 (true) if expr is NULL, otherwise 0 (false).

So it is never >0

Hope this answers your question.

Re: SQL case eqvuivalent in qlikview

Fri, 29 Jun 2012 18:57:16 GMT

Yes sir, it does.

Thank you.