
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
=round(Yourfield/1000)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tried, when i export to excel im not able to perform calculation on this column.
That is my major concern.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=round(TimeinMS/1000) as [Time in Seconds]
=interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is TimeInMs a number or an actual time field?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Its a number stored in db (datatype: Bigint)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I guess you got what you need... but this could be the other way to do this
=Interval(Interval#(TimeInMS/1000, 'ss'), 'ss')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous Replies
-
- 1
- 2
- Next Replies »