8 Replies Latest reply: Oct 23, 2012 4:50 AM by Niklas Harding

# Grouping of values in a barchart

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?

• ###### Re: Grouping of values in a barchart

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

• ###### Re: Grouping of values in a barchart

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?

• ###### Re: Grouping of values in a barchart

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

• ###### Re: Grouping of values in a barchart

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

• ###### Re: Grouping of values in a barchart

I do aging by:

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

Buckets:

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

INTERVALMATCH (DueDays)

Start,

End

RESIDENT Buckets;

3. using the bucket as a dimension on the chart

Jonathan

• ###### Re: Grouping of values in a barchart

Thanks buddy... il try solve it like that

• ###### Re: Grouping of values in a barchart

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

Jonathan

• ###### Re: Grouping of values in a barchart

its been done, thanks