Convert Milliseconds to Seconds

[puneetagarwal]

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

[sunny_talwar]

what was going wrong when it was exported? it was not a number?

[puneetagarwal]

Let me explain you in detail.

Suppose after exporting the values we have values like

50
30
10
90
15
If we want to sum for the above values it should give the result as 195. But it is giving as 0.

Hope it explains

[puneetagarwal]

Yes, Its a number. but,after exporting also we see the number but with a Green asking me to convert that values to number to perform calculations

[sunny_talwar]

I am confused... when exported to Excel, is this read as number or text? Can you share the exported Excel or it's image with one of the populated cells highlighed

[sunny_talwar]

Okay, not that makes complete sense.. Let me ask you 2 things

1) Did Chanty's response solve your problem... if it did... no point moving foward

2) If Chanty's response did not solve your problem.... which object are you using here to display your number?

[puneetagarwal]

See the column AD(TimeInSec)