topic Time Dimension in QlikView

Time Dimension

Thu, 05 Nov 2009 04:44:56 GMT

I have event records in my data source. If I dimension the count of events over the timestamp (minutes) of each record, I will only have a dot on the chart if at least one event happen that minute.

How can I dimension the count of events such that the x-axis of my chart will display every minute regardless whether an event actually happens? I thought the "Continuous" option under Axes will help, but it doesn't seem to be the case.

IntervalMatch is next on my list, but the scripting seems a bit advance for me because I assume I will need to autogen a master calendar? And I am not sure if it will work at the granularity of minutes.

Thanks in advance.

Time Dimension

johnw — Thu, 05 Nov 2009 05:19:18 GMT

I would have expected a continuous X axis to solve the problem. I suspect there's something peculiar going on, but have no guesses what at the moment.

I wouldn't go with the minute-by-minute calendar. If the calendar is connected to your data, you'll still only get minutes for which you have data points. To get all minutes, you'd have to disconnect it from your data and match the data up with an IF, but matching minute-by-minute events to a disconnected minute-by-minute calendar would take an impossibly high amount of CPU, and likely never complete.

Time Dimension

Thu, 05 Nov 2009 08:21:23 GMT

You need to tell the script that it is a timestamp field and then in the chart properties on the number tab, set the x-axis to be a timestamp also. See the attached file, it should work fine.

Please let me know if you have any questions.

Time Dimension

Thu, 05 Nov 2009 08:26:24 GMT

It looks like it is not accepting the attachment so here is the code in the script I used :

Time Dimension

Thu, 05 Nov 2009 08:37:37 GMT

and here is the resulting chart:(sorry for the lame screenshots. Email me if you need the qvw : jcs@qlik.com)

Time Dimension

Thu, 05 Nov 2009 11:18:38 GMT

Thanks people.

Jcs, thanks for pointing out the number configuration. Apparently that's the fine point I missed. In fact, the x-axis number config won't appear until I checked the Continuous option.

I guess not having the scroll bar would be the trade-off I have to live with.

Time Dimension

Thu, 05 Nov 2009 11:37:46 GMT

One more question.

My event records also record duration.

event 1 = Nov 4 2009 9:35:00 pm, lasted 15 minutes

event 2 = Nov 4 2009 9:40:00pm, lasted 5 minutes

What is the proper dimension expression to calculate the number of event-in-progress at any time-interval? And if possible, the interval can be scaled dynamically? Such that:

between 9:30-9:44:59, 2 events are happening (15 minute interval)

between 9:47:00-9:47:59, 1 event is happening (1-minute interval)

I think I should use interval() somewhere, but not sure how...