Creating Date and Time Intervals

[luminassv8]

Hi.  I have found a couple of treads dealing with either Date or Time intervals and although being new to QlikView have managed to implement these functions in my models.

I am busy with a project where I need to present data over an extended period being a couple of days but with intervals of say 10 minutes. Therefore a combination of both date and time in one.

My ultimate goal would be to use a slider for visual impact.

Can somebody please help with a dimension expression or script to solve this challenge?

[MarcoWedel]

please post some sample data and your expected result.

thanks

regards

Marco

[ecolomer]

See this:

Example for IntervalMatch function

[vkhassanov]

Hi,

Not sure if you have solved it but I have just run over your question.

To create 10 min intervals in your case the solution is to add one more line to your facts table (the one with timestamps) as follows:

Timestamp(Floor(timestamp) + MakeTime(Hour(timestamp),Floor(Minute(timestamp),10))) as [10 min interval],