Group x-axes values

[#1]

Dear Qlikview community,

I'm trying to create a bar chart where I group the x-axis values. However I do not succeed very well at that. How can I group my x-axis values?

Example:

I have data like:

Age     Length

5     1000

12     320

3     120

1     300

I want to display this on a graph with a grouping like 0-5; 5-10; ... The result should be:

Age     Length

5-9          1000

10-14       320

0-4          420

What is the best way to achieve this?

Thanx!

[#2]

SMART! That did the trick

Thank you very much!!

[#3 · Accepted solution]

After all this time I found another solution to the very first topic I've created. There exists a function 'class()' which can group dimensions like this without altering the script code.

[Aleman]

Awesome, worked for me.

Thanks!