Discussion Board for collaboration related to Qlik Education.
can anyone tell me how can i multipla an interval of time by a number
00:01:00 multiply by 7 equal 00:07:00
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?
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
Thank you Jonathan it Works
I wasn't sure that this is what you were asking for. Great that it worked. Could yo please mark Jonathans answer as correct?