topic Re: Histogram with variable intervals in QlikView

Histogram with variable intervals

Tue, 12 Feb 2013 14:44:15 GMT

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.

Re: Histogram with variable intervals

Tue, 12 Feb 2013 15:22:07 GMT

look at the intervalmatch() function

Re: Histogram with variable intervals

Tue, 12 Feb 2013 15:22:31 GMT

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

Re: Histogram with variable intervals

Wed, 13 Feb 2013 08:07:12 GMT

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