# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor

## time interval between 0 and 1

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
1 Solution

Accepted Solutions
MVP

## Re: time interval between 0 and 1

Create something like this

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

## Re: time interval between 0 and 1

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?

New Contributor

## Re: time interval between 0 and 1

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
MVP

## Re: time interval between 0 and 1

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?

New Contributor

yes it's correct
MVP

## Re: time interval between 0 and 1

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?

New Contributor

## Re: time interval between 0 and 1

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

## Re: time interval between 0 and 1

Create something like this

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

## Re: time interval between 0 and 1

You are the best! it works 😉