# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## Convert Milliseconds to Seconds

Hi All,

We have a column in db where the values gets store in Milliseconds (Bigint), I need to covert the Milliseconds value into seconds in qlikview.

When we export the Data/Excel we should be able to perform Aggregate calculation (Sum,Avg) etc.

Sample Values:

 TimeInMS Time in Seconds 420000 420 2640000 2640 420000 420 120000 120 420000 420

Regards,

Puneet Agarwal

1 Solution

Accepted Solutions
Partner
Author

Tried this function , i was successfully able to convert into seconds.

But when i export to excel i am not able to perform the calculation on that column (Avg,Sum) etc.

15 Replies
MVP

try this

=round(Yourfield/1000)

Partner
Author

Tried, when i export to excel im not able to perform calculation on this column.

That is my major concern.

Master

=round(TimeinMS/1000) as [Time in Seconds]

=interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

MVP

try this

interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

MVP

Is TimeInMs a number or an actual time field?

Partner
Author

Its a number stored in db (datatype: Bigint)

Partner
Author

Tried this function , i was successfully able to convert into seconds.

But when i export to excel i am not able to perform the calculation on that column (Avg,Sum) etc.

MVP

I guess you got what you need... but this could be the other way to do this

=Interval(Interval#(TimeInMS/1000, 'ss'), 'ss')

Partner
Author

Tried this function , i was successfully able to convert into seconds.

But when i export to excel i am not able to perform the calculation on that column (Avg,Sum) etc.

Note: The user wants to perform the mathematical calculation after exporting the excel on this column.

Community Browser