Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how to create 30 min ranges using interval match

Hi folks,

I want create a time range dimension to have the following values in 30 minutes range:

7:00 AM

7:30 AM

8:00 AM

8:30 AM

until 11:30 PM

So I have a time field that shows for example

07:15 AM

3:23 PM

4:54 PM

If I select 7:15AM I should see this date under the 7:00 to 7:30am slot.

I created an inline like this but it is not working when I do the intervalmatch with the time field from my database.

LOAD * INLINE [

Start, End, Slot

07:00, 07:29, 7:00 AM

07:30, 07:59, 7:30 AM

08:00, 08:29, 8:00 AM

];

It looks like the interval match works with numbers but when I use time it doesn't work. Any suggestion of what is the formatting to use?

1 Solution

Accepted Solutions

Re: how to create 30 min ranges using interval match

Hi,

please close this thread and proceed with this discussion in your thread

creating 30min range

thanks

regards

Marco

2 Replies

Re: how to create 30 min ranges using interval match

You can also use the Class() function in this case

Re: how to create 30 min ranges using interval match

Hi,

please close this thread and proceed with this discussion in your thread

creating 30min range

thanks

regards

Marco

Community Browser