Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

if statements with Hours and minutes

Hi ,

I have taken reload hour and minutes using below expression.

Time(Frac(ReloadTime()),'hh:mm')

Now i want to check that hour and minute with pre define minutes

If that Time(Frac(ReloadTime()),'hh:mm') value is grater than 06:30 i want to say 'Y' and else 'N'

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: if statements with Hours and minutes

This will do it:

=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
Highlighted
MVP
MVP

Re: if statements with Hours and minutes

This will do it:

=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted

Re: if statements with Hours and minutes

=if(Time(ReloadTime(),'hh:mm') > time#('06:30','hh:mm'), 'Y','N') as TimeFlag

Highlighted
Partner
Partner

Re: if statements with Hours and minutes

This way you can change the time limit as well

if(Num(Time(Frac(ReloadTime()),'hh:mm'))>Num(Time(Frac('06:30'),'hh:mm')), 'Y', 'N')

Highlighted
Partner
Partner

Re: if statements with Hours and minutes

Thanks jonathan