Help time range

Wed, 13 May 2015 15:25:37 GMT

Hi Guys, very new, so sorry if this is a stupid question.

I need to be able to select data in between specific hours of a selected day 05:00am and 15:00pm, Have no idea. do i need to create two time variables to do this and if so how do i go about it. Been on google for a while with no luck.

Ill carry on googling tomorrow , if i come right ill post it here but struggling.

Re: Help time range

Thu, 11 Jun 2015 05:41:48 GMT

Just to let you know how i fixed this. I did this by mapping the hours in the load script. Below is what i did.

[TEMP TIMERANGE]:

LOAD * INLINE [

StartDate, EndDate, Shift

05:00:00, 14:59:59, Shift A

15:00:00, 23:59:59, Shift B

24:00:00, 04:59:59, NoShift

];

[TIMERANGE]:

NoConcatenate Load

Shift,

MakeTime(Hour(StartDate), Minute(StartDate), Second(StartDate)) as StartDate,

MakeTime(Hour(EndDate), Minute(EndDate), Second(EndDate)) as EndDate

Resident [TEMP TIMERANGE];

Drop Table [TEMP TIMERANGE];

Kind regards

topic Help time range in QlikView

Help time range

Re: Help time range