Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jaspal_icon
Partner - Creator
Partner - Creator

QlikView Milliseconds till 3 Decimal Issue

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

0 Replies