Discussion Board for collaboration on QlikView Scripting.
I want create a time range dimension to have the following values in 30 minutes range:
until 11:30 PM
So I have a time field that shows for example
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?
Go to Solution.
please close this thread and proceed with this discussion in your thread
creating 30min range
You can also use the Class() function in this case