Conditional logic with TimeStamp

[lucasdavis500]

Hello,

I'm trying to include observations in a table in qlikview where the timestamp is greater than a negative number, but can't seem to get my formula correct. The data is imported from an excel worksheet and is formatted as HH:MM:SS. Instead of fixing any errors in individual excel worksheets I would prefer to do this in Qlikview script.

I've tried:

IF(TotalTime_hhmmss > interval(0) , TotalTime_hhmmss)

as well as

IF(TotalTime_hhmmss > interval(0, 'hh:mm:ss') , TotalTime_hhmmss)

as well as

IF(TotalTime_hhmmss >'00:00:00', TotalTime_hhmmss)

and variations of interval('00:00:00', 'hh:mm:ss'), interval(00:00:00, 'hh:mm:ss'), etc...

What is the best way to work with timestamps in Qlikview?

[sunny_talwar · Accepted solution]

May be this

If(TotalTime_hhmmss >= MakeTime(0, 0, 1) , TotalTime_hhmmss)

[lucasdavis500]

This works! Thank you! I wasn't aware of the MakeTime() Function, but I will keep it in mind