Grouping of values in a barchart

[#1]

Hi QC

I have a problem i havent been able to solve... the x-axe shows time (in days) and y-axe shows amount.

I wanted to group days 0 - 4 and its values (the green bars below) in one bar, then days 5 - 9 in one bar (the orange bars) and so forth...

Ive done this in excel on the same data by grouping the days 0 - 4 in a pivot table and make the chart based on the data from the pivot table, but i havent been able to pull it off in Qlikview.

Days are entered as a dimension and amount as an expression, and the chart is made in the QV IE Plugin.

Anybody have a solution on how to do this?

[matt_crowther]

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

@QlikviewBI

Qlikview Design Blog: http://QVDesign.wordpress.com

[#3]

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?

[#4]

Bump... anybody with an idea how to do the =class function with specific intervals?

[#5]

bump, anyone with an idea how to solve this issue with =class function having specific intervals?

[Anonymous · Accepted solution]

I do aging by:

1. setting up buckets using inline script statements that have from and to amounts

Buckets:

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

    ❤️ months over, 61, 90

    >3 months over, 91, 9999

];

2. running the transaction details through an interval match against this buckets table

INTERVALMATCH (DueDays)

LOAD

     Start,

     End

RESIDENT Buckets;

3. using the bucket as a dimension on the chart

Jonathan

[#7]

Thanks buddy... il try solve it like that

[Anonymous]

Great. May be worth you marking post as solved to take out of unsolved list.

Jonathan

[#9]

its been done, thanks