topic aggr function with rangesum(before()) not working in QlikView

aggr function with rangesum(before()) not working

Mon, 07 Jan 2013 07:35:02 GMT

Dear all,

anyone can help me why this function doesn't return any value?

exp :

sum(

Aggr(

if(RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))=3,1)

,CUSTOMER_ID

)

thanks

Re: aggr function with rangesum(before()) not working

khadeer — Mon, 07 Jan 2013 07:37:28 GMT

Try this

Aggr(

sum(

if(RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))=3,1))

,CUSTOMER_ID

)

Re: aggr function with rangesum(before()) not working

er_mohit — Mon, 07 Jan 2013 07:41:26 GMT

hey plz clarify what's you actually want in output. i didn't get you exactly

Re: aggr function with rangesum(before()) not working

Mon, 07 Jan 2013 07:48:19 GMT

i think you miss this

sum( )CUSTOMER_ID

Re: aggr function with rangesum(before()) not working

Mon, 07 Jan 2013 07:54:58 GMT

i'm sorry..it's still not working..i clarify in a moment..

thanks..

Re: aggr function with rangesum(before()) not working

Mon, 07 Jan 2013 08:03:51 GMT

thanks to all for fast response..

here is my little problem..

i want to count CUSTOMER_ID which have transaction for the last 3 months..it said Loyal Customer..

if the customer_id doesn't have 3 transactions..it's not counted..

because count(if can not be used..so i try to manipulate using sum(aggr(rangesum(..which sometime working..but this case not..

1st exp :

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

2nd exp :

RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))

3rd exp :

if(RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))=3,1)

4th exp :

sum(

Aggr(

if(RangeSum(Before(if(sum(SALES_VALUE_GROSS)>0,1),0,3))=3,1)

,CUSTOMER_ID

)

as everyone see..the 4th exp is just summary the 3rd exp..but unfortunately it is not working..

thanks