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)
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.
