Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
If(TotalTime_hhmmss >= MakeTime(0, 0, 1) , TotalTime_hhmmss)
May be this
If(TotalTime_hhmmss >= MakeTime(0, 0, 1) , TotalTime_hhmmss)
This works! Thank you! I wasn't aware of the MakeTime() Function, but I will keep it in mind