topic Re: time range in QlikView

time range

Fri, 22 Feb 2013 13:12:47 GMT

I have the rawdata for surveys done at each clinic

there is a column for time where its written in this format "hh.mm.Ss"

and another table for time of survey for each clinic to be done for example. 10:00pm - 9:00 am. so the common between 2 tables is Location

how can i check if the survey is done between that time or not??????

Re: time range

er_mohit — Fri, 22 Feb 2013 13:16:05 GMT

try this, as per your time format,like this

time(fieldname,hh:mm:ss) as time_survey

on both fields. then you get right format

Re: time range

manideep78 — Fri, 22 Feb 2013 13:42:37 GMT

Hi,

See attached qvw and let me know if there are any issues

Re: time range

Fri, 22 Feb 2013 13:53:15 GMT

this is good but doesnt help when we have time range for 23:00:00 to 04:00:00

Re: time range

jagannalla — Tue, 26 Feb 2013 08:14:50 GMT

Hi,

How you are saying that starttime 23:00 is yesterday's time. It can also be next day 23:00 time. We should have datetime in this case,then only you can achive your result.

For eg below one,KPHB result is expecting today's 23:00 time.

Clinic:
LOAD * INLINE [
    Clinic, Time, Location
    A, 09:00:00, Abids
    B, 08:34:45, Koti
    C, 10:43:56, Miyapur
    D, 12:12:12, Ameerpet
    E, 05:08:24, KPHB
];
Inner Join
LOAD * INLINE [
    Location, StartTime, EndTime
    Abids, 08:00, 10:00
    Koti, 09:00, 11:00
    Miyapur, 10:00, 12:00
    Ameerpet, 11:00, 12:00
    KPHB, 23:00, 06:00
];

ResiClinic:
LOAD Location, If(Time >= StartTime and Time <= EndTime,'T','F') as Flag Resident Clinic;

Hope it helps you

Cheers!!

Jagan