Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor

interval


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,

4 Replies
morris70
Valued Contributor

Re: interval

Hi

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?

MVP
MVP

Re: interval

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mario-sarkis
Contributor

Re: interval

Thank you Jonathan it Works

morris70
Valued Contributor

Re: interval

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

Community Browser