QlikView Milliseconds till 3 Decimal Issue

jaspal_icon — Wed, 24 Jul 2013 12:04:43 GMT

Hello All,

I am interested to know that if QlikView Round of the Milliseconds till 3 decimal?

As I tried to Load Date Time from Excel in QlikView, which contains Timestamp till 5 Decimal of milleseconds.

So if Date is "01-Jan-2013 10:00:00 123456" then QlikView will represent "01-Jan-2013 10:00:00 123000".

Do anyone know the reason behind it?

Might be it is not practical to have milliseconds calculation for more than 3 Decimal, but QlikView should not do rounding or must have return same value as expected.

Let me know if anyother solution is there to resolve this.

I am using QlikView 11.2. I tried to change TimestampFormat to but no use.

Thanks in Advance

Regards

topic QlikView Milliseconds till 3 Decimal Issue in QlikView

QlikView Milliseconds till 3 Decimal Issue