Conditional logic with TimeStamp

lucasdavis500 — Tue, 21 Feb 2017 16:49:20 GMT

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?

Re: Conditional logic with TimeStamp

sunny_talwar — Tue, 21 Feb 2017 16:51:02 GMT

May be this

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

Re: Conditional logic with TimeStamp

lucasdavis500 — Tue, 21 Feb 2017 17:11:18 GMT

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

topic Conditional logic with TimeStamp in QlikView

Conditional logic with TimeStamp

Re: Conditional logic with TimeStamp

Re: Conditional logic with TimeStamp