topic Re: Creating Date and Time Intervals in QlikView

Creating Date and Time Intervals

luminassv8 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Creating Date and Time Intervals

MarcoWedel — Sat, 20 May 2017 17:31:53 GMT

please post some sample data and your expected result.

thanks

regards

Marco

Re: Creating Date and Time Intervals

ecolomer — Sat, 20 May 2017 17:41:44 GMT

See this:

Example for IntervalMatch function

Re: Creating Date and Time Intervals

vkhassanov — Thu, 24 Aug 2017 12:13:17 GMT

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],