Time Calendar

Tue, 06 Oct 2009 18:55:09 GMT

Dear Community:

I am trying to build a minute-by-minute histogram of the usages of our QlikView Session CALs. In order to make this benefitial I need to build a calendar, I cannot get my head around how to do this.

I have a start and end time of a certain action. Now I would like to build a 'time calendar' in which every minute of the day has its own row. I am just not sure how to do this with Time instead of Date. Does somebody having a code snippet addressing this problem and would like to share this?

The data I is the following:

Start, End
08:41:59, 08:45:10

(seconds can be eliminated if that makes it easier)

And I would like to get the following out.

08:41
08:42
08:43
08:44
08:45

Anybody an idea?

Thanks. JD

Time Calendar

prieper — Tue, 06 Oct 2009 19:02:12 GMT

Think that AUTOGENERATE() should help you in this case. If you wish to have a record for each second, you need to divide day by 24 in order to get hours and again by 60 in order to get seconds. Please find a small sample attached, you may wish to update it with a start- and an end-date, the differential would be then the required input for the AUTOGENERATE.

HTH
Peter

topic Time Calendar in QlikView

Time Calendar

Time Calendar