topic interval in Qlik Learning Discussions

interval

mario-sarkis — Fri, 21 Nov 2014 15:09:49 GMT

hey all

can anyone tell me how can i multipla an interval of time by a number

Example

00:01:00 multiply by 7 equal 00:07:00

Thank you,

Re: interval

Anonymous — Mon, 24 Nov 2014 07:53:47 GMT

Could you please clarify your question a bit more. Can you explain what you are trying to achieve and why.

for example if the time was 00:02:00 or 00:59:00 what answer would you expect?

Re: interval

jonathandienst — Mon, 24 Nov 2014 08:10:37 GMT

An interval is just a number, in decimal days (eg 1 = 1 day/24 hours, 1.25 = 28 hours, 0.25 = 6 hours/360 minutes). So an interval can be multiplied like this

=Interval(Interval#('00:01:00', 'hh:mm:ss') * 7, 'hh:mm:ss')

=Interval(Elapsed * 7, 'hh:mm:ss') // using field [Elapsed] containing an interval

HTH

Jonathan

Re: interval

mario-sarkis — Mon, 24 Nov 2014 09:44:31 GMT

Thank you Jonathan it Works

Re: interval

Anonymous — Mon, 24 Nov 2014 10:19:22 GMT

Hi Mario

I wasn't sure that this is what you were asking for. Great that it worked. Could yo please mark Jonathans answer as correct?

Regards