topic Compare time field in QlikView

Compare time field

slvedva123 — Sat, 11 Dec 2021 12:08:14 GMT

Hi,

Maybe someone can help with correct script. I have data table like below:

For each line I want to compare the time window and give value.

Like if time is from 14:00:00 till 14:59:59, than value 1; if time is from 15:00:00 till 00:00:00, than 2.

I tried with this :

if(time(time([TIMEFIELD],'hh:mm:ss'))>='14:00:00' and time(time([TIMEFIELD],'hh:mm:ss'))<='14:59:59','1','2'), but it's don't work, for all records system give value 2.

Re: Compare time field

AshutoshBhumkar — Sat, 11 Dec 2021 12:59:02 GMT

Hello,

The same expression works at my end.

Can you share some sample data ?

Thanks,

Ashutosh

Re: Compare time field

slvedva123 — Sat, 11 Dec 2021 13:14:58 GMT

I use app on QlikSense server, how I can share these data?

Re: Compare time field

slvedva123 — Sat, 11 Dec 2021 13:26:42 GMT

Maybe it's somehow related, that this original field look like this: 2021-12-11 15:26:50 and with time funtion I take time 15:26:50

Re: Compare time field

AshutoshBhumkar — Sat, 11 Dec 2021 13:32:24 GMT

That should still work fine.

Re: Compare time field

slvedva123 — Sat, 11 Dec 2021 16:17:50 GMT

I use this function to convert time - time(time([INSERTDTM],'hh:mm')), but when I download this field in excel, it's show like this - "07.01.2021 13:06:15", how to really convert, that system take only time, without date?

Re: Compare time field

AshutoshBhumkar — Sat, 11 Dec 2021 17:48:13 GMT

Try Tmestamp()

Timestamp(Timestamp#(INSERTDTM,'dd.mm.yyyy hh:mm:ss'),'hh:mm:ss')