topic Time calculation in load statement or chart in QlikView

Time calculation in load statement or chart

Tue, 13 Jan 2015 10:34:11 GMT

Hello experts

Help me evaluate

=Interval((Date#(EQM_AUSBS,'M/D/YYYY')+time(EQM_AUZTB,'hh:mm:ss'))-(Date#(EQM_AUSVN,'M/D/YYYY')+time(EQM_AUZTV,'hh:mm:ss')),'hh:mm')

in chart or in load statement.

Thanks,

Ashif Tadvi

Re: Time calculation in load statement or chart

tresB — Tue, 13 Jan 2015 11:01:07 GMT

Like attached?

Your dates and times are proper timestamps, so no need to force parsing them.

Re: Time calculation in load statement or chart

Tue, 13 Jan 2015 11:16:06 GMT

Hi,

try this expression, =Interval((num(Date#(EQM_AUSBS,'M/D/YYYY')&' '&time(EQM_AUZTB,'hh:mm:ss')))-(num(Date#(EQM_AUSVN,'M/D/YYYY')&' '&time(EQM_AUSVN,'hh:mm:ss'))),'hh:mm')

And I guess you need to show it against one more dimension.

Regards,

Amay