topic aggr funcation in QlikView

aggr funcation

Thu, 21 Jan 2010 06:01:15 GMT

we want count of sales unit code whose sum(Amount)>=1000000

count

(distinct aggr( if(sum(AMOUNT)>=1000000

),SalesUnitCode))

it's show zero

please help urgent basic

Thu, 21 Jan 2010 06:08:52 GMT

use numcount

Thu, 21 Jan 2010 06:23:13 GMT

where we use numcount

Thu, 21 Jan 2010 07:13:08 GMT

please tell me the result what it should come for ur expression

Thu, 21 Jan 2010 07:45:15 GMT

expersion worng

Thu, 21 Jan 2010 08:12:50 GMT

Try this

calculate the sum of Amount at the backend i.e script

load sum(Amount) as xyz

resident TableName

group by code;

then count(if(xyz>1000,code))

Thu, 21 Jan 2010 09:59:34 GMT

Test with

=sum( aggr( if(sum(AMOUNT)>=1000000 , 1 , 0) , SalesUnitCode))

regards