Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
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
jonathandienst

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
jonathandienst

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

Kushal_Chawda

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

todtliat01
Partner
Partner

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')

anuradhaa
Partner
Partner
Author

Thanks jonathan