This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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.
View solution in original post
Tried, when i export to excel im not able to perform calculation on this column.
That is my major concern.
=round(TimeinMS/1000) as [Time in Seconds]
=interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField
interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField
Is TimeInMs a number or an actual time field?
Its a number stored in db (datatype: Bigint)
I guess you got what you need... but this could be the other way to do this
=Interval(Interval#(TimeInMS/1000, 'ss'), 'ss')
Note: The user wants to perform the mathematical calculation after exporting the excel on this column.