topic Re: Problem of memory with sum(if(isnull(X),Y)) in QlikView

Problem of memory with sum(if(isnull(X),Y))

azaia_synt — Wed, 27 May 2015 14:22:28 GMT

Goodmorning,

I have a problem of memory using the formula in object.

I must count the number of record that have some field null; have I an alternative to the formula sum(if(isnull(X),Y))? because with 200K record the application is not able to show me the table where I use the formula.

Thanks

Re: Problem of memory with sum(if(isnull(X),Y))

Clever_Anjos — Wed, 27 May 2015 16:04:58 GMT

How those fields are related? Are they on same table?

Re: Problem of memory with sum(if(isnull(X),Y))

azaia_synt — Wed, 27 May 2015 16:10:20 GMT

Yes they are on the same table and all X field are string, Y instead is a integer value to 1.

Re: Problem of memory with sum(if(isnull(X),Y))

Clever_Anjos — Wed, 27 May 2015 16:18:00 GMT

Please check if SUM(Y) - SUM({<X={"*"}>}Y) brings same result and performs better