topic Re: Aggr Function - wrong output in QlikView

Aggr Function - wrong output

Wed, 15 Jan 2014 05:12:36 GMT

HI,

I have created the following expressions which are displayed in a Stacked Bar.

1) Inventory <= 10 Days

Sum(if(Aggr((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30),[Territory Name]) <= 10,1,0))

2) Inventory Between 10 to 30 Days

sum(if((Aggr((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30),[Territory Name]) > 10) and

(Aggr((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30),[Territory Name]) <= 30),1,0))

3) Inventory > 30 Days

sum(if(Aggr((Sum ([CLosing_STK Value]) + Sum ([Intran_STK Value])) / (Sum ([Avg Value])/30),[Territory Name]) > 30,1,0))

Expression No.2 and 3 are displaying correct value whereas Expression 1 does not. It shows a higher value.'

Am i doing something wrong ? Is there any other way to display the output.

Thanks in advance.

Re: Aggr Function - wrong output

Wed, 15 Jan 2014 06:34:09 GMT

I'm not sure that understand what you mean completely but I test it on some sample data and it works correctly

but maybe my attachment helps you

Re: Aggr Function - wrong output

Wed, 15 Jan 2014 06:50:29 GMT

HI Behnaz,

Thanks for you reply.

The issue was - it was counting Null value also, which is in 'Inventory <= 10 Days'. I need to count the values which are Zero. But not which are NULL.