class with aggr function boundaries

Anonymous — Tue, 07 Aug 2012 14:50:42 GMT

I have table with calculated dimension using class and aggr functions

The result looks something like this

To obtain this I forced all days lower than -30 in the "-30 <= Days <0" bucket and averything larger than 150 Days in the

"150 <= Days < 180" bucket

So what I really want to display for the first and the last row is

"Days < 0" instead of "-30 <= Days < 0" and

"150 <= Days" instead of "150 <= Days < 180"

The calculated dimension expression is

class(
aggr(if(Sum(Stock) < 0, -1, if(Sum(Stock)/sum(OutGoing*-1)>150,155,
round(Sum(Stock)/sum(OutGoing*-1)))),
Product,Warehouse

),
30, 'Days', -30)

Can anyone tell me how to do this

topic class with aggr function boundaries in QlikView