Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between times

I want to do something very simple but it is not working.

I have a time column and I want to see if that time is greater than 6pm. if I simple do an if(mytimecolumn > maketime(18,0,0), etc, that returns false even when it is true, like when the time is noon.

I tried to use Time# for that but even than does not work.

What is the best approach to do this?

1 Reply
hector
Specialist
Specialist

hi, how about this?

if(hour(mytimecolumn) >= 18, true(), false())

Rgds