Histogram with variable intervals

[#1]

Hello,

I have a table of records, each having a time (for "time elapsed in hours") field. I want to create a histogram over the number of records with the bins being

0 <= time < 4h

4h <= time < 1d

1d <= time < 7d

7d <= time < 30d

... and so on. I looked at the Class function, but since the time intervals are different for each bin I think it cannot be used here. I also would really like to have the bins labeled like shown above, e.g. '7d' instead of '168h' for better readability.

Is there any way to do this?

Thanks in advance.

[#2 · Accepted solution]

look at the intervalmatch() function

[#3]

http://community.qlik.com/docs/DOC-3557

[#4]

Thanks so much, this is just was I was looking for!