Try looking at the class() function in the Help File, it allows you to place your values in buckets (0-4,5-10,-11-15 etc).
Hope that helps,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com
ive tried to toy around with the class function without getting it to work fully, as i wanted it to...
My time/days is calculated through this dimension: =(NetWorkDays(BDW_ABS_ORDER_Date, ABS_PACKINGNOTE.DELIVERYDATE, $(=SH_Dage)))
and my amount is: Sum(DELEVERY_SCAN.QUANTITY)
ive tried this:
=class(NetWorkDays(BDW_ABS_ORDER_Date, ABS_PACKINGNOTE.DELIVERYDATE, $(=SH_Dage)),4)
but that shows it like this:
it groups by 4 every time... and i wanted to define the value of the group so i can do: 0 - 4, 5 - 9, 10 - 20 etc. i havent managed to figure out how to put that into the formula above, any ideas?
I do aging by:
1. setting up buckets using inline script statements that have from and to amounts
LOAD * INLINE [
Bucket, Start, End
>7 days remain, -999, -7
Due this week, -6, 0
<1 month over, 1, 30
<2 months over, 31, 60
<3 months over, 61, 90
>3 months over, 91, 9999
2. running the transaction details through an interval match against this buckets table
3. using the bucket as a dimension on the chart