topic Re: time interval between 0 and 1 in QlikView

time interval between 0 and 1

matbelli — Wed, 25 Nov 2020 16:16:04 GMT

Hi, i have to check if Intervallo is between 0 and 1 hour, how can i do it? thanks

anag_nome_sala	Gioco	anag_nome_giorno	giorno_partita	Lunedì_open	Orario_Fine_Part	win	Orario_Fine_Part	Intervallo
								-
AMERICA	BINGO	lun	24/09/2018_201	09:00:00	04:44:00	15,66	04:44:00.0000000	04:16:00
AMERICA	BINGO	lun	24/09/2018_200	09:00:00	04:38:00	10,44	04:38:00.0000000	04:22:00
AMERICA	BINGO	lun	24/09/2018_199	09:00:00	04:31:00	6,96	04:31:00.0000000	04:29:00
AMERICA	BINGO	lun	24/09/2018_198	09:00:00	04:26:00	10,44	04:26:00.0000000	04:34:00
AMERICA	BINGO	lun	24/09/2018_197	09:00:00	04:20:00	10,44	04:20:00.0000000	04:40:00
AMERICA	BINGO	lun	24/09/2018_196	09:00:00	04:20:00	20,88	04:20:00.0000000	04:40:00

Re: time interval between 0 and 1

sunny_talwar — Fri, 11 Jan 2019 12:16:06 GMT

What is the expected output based on the sample data you have provided? Also, are you doing this in the script or front end of the app?

Re: time interval between 0 and 1

matbelli — Fri, 11 Jan 2019 12:43:32 GMT

I am doing this in front end, i have these 2 fields: Lunedì_open, Orario_Fine_Part and i have to check if Orario_Fine_Part is less than an hour from Lunedì_open. in other words i have to check if Orario_Fine_Part is between Lunedì_open and Lunedì_open+1 h.
thanks

Re: time interval between 0 and 1

sunny_talwar — Fri, 11 Jan 2019 13:01:34 GMT

In the above example rows, none of your rows pass the condition, right? For all of the rows, Orario_Fine_Part is NOT between Lunedì_open and Lunedì_open+1 h, correct?

Re: time interval between 0 and 1

matbelli — Fri, 11 Jan 2019 13:05:11 GMT

yes it's correct

Re: time interval between 0 and 1

sunny_talwar — Fri, 11 Jan 2019 13:09:06 GMT

Okay, so what exactly do you want to see when the condition is NOT met or when it is met? Anther column where it says... Yay!! Condition Met. Nay!! it failed? Or something along those lines or you want to exclude those rows for your chart where the condition have not met? What exactly are you looking to do?

Re: time interval between 0 and 1

matbelli — Fri, 11 Jan 2019 13:11:27 GMT

I would like to have the column with Yay if the condition is met and Nay if it's not

Re: time interval between 0 and 1

sunny_talwar — Fri, 11 Jan 2019 13:14:18 GMT

Create something like this

If(Orario_Fine_Part >= Lunedì_open and Orario_Fine_Part <= Lunedì_open + MakeTime(1),
'Yay',
'Nay')

Re: time interval between 0 and 1

matbelli — Fri, 11 Jan 2019 13:17:42 GMT

You are the best! it works 😉