topic Re: Counting a value where value is a positive/negative number in QlikView

Counting a value where value is a positive/negative number

Thu, 05 Dec 2013 21:07:07 GMT

Hey Guys,

Wondering if anyone can help. I am trying to create an expression if possible that is a sum of a field in my table loaded. But if possible i only want to count 1 in the value in the table is positive. I have both positive and negative numbers in my table.

I thought it might be as simple as:

if(num1 > 0,NumericCount(num1),0)

Any help is much appreciated, Thanks.

Re: Counting a value where value is a positive/negative number

wallinpeter — Thu, 05 Dec 2013 21:11:56 GMT

I would create new field in script.

Add to new column to table....

if (value>0,1,value) as NewValue

create expression....

sum(NewValue)

Re: Counting a value where value is a positive/negative number

Anonymous — Thu, 05 Dec 2013 21:17:04 GMT

sum(if(Field>0,1,0))

Re: Counting a value where value is a positive/negative number

fred_s — Thu, 05 Dec 2013 21:20:46 GMT

Hi David,

Maybe this one?

See attachment

Re: Counting a value where value is a positive/negative number

Thu, 05 Dec 2013 21:32:51 GMT

got it guys thanks.

sum(if(ARR_DELAY>0,1,0))