topic Problem Counting in QlikView

Problem Counting

Mon, 20 Dec 2010 19:45:50 GMT

I have a table (chart), with name, number and age

in one of the records the number and age are void, because the values do not exist in DB.

and another thing in my table there is an average "age ":

sum (age) / count (age)

but in the "count", it also count what is null ...

Name_Number_Age

A______200____15

B______800____23

C______360____20

D______150____31

D_______ - _____ -

count(age) = 5

I've tried to use:

if (age> = 0, count (age))

but the end result is "null" ( - )

if (age> = 0, count (age)) = - (null)

what is wrong with this formula?

Problem Counting

marcel_olmo — Mon, 20 Dec 2010 19:50:53 GMT

if you upload some code or a little QV file it could be easier to us to help you.

Cheers!!

Problem Counting

Mon, 20 Dec 2010 20:41:14 GMT

try count(if(Age>=0 , Age , Null())) to count all the Age positive or greater than 0

Problem Counting

Mon, 20 Dec 2010 20:57:54 GMT

thank you ... was what I was seeking.