How to format Qlikview Timestamp upto microseconds?

Fri, 20 Nov 2020 18:02:30 GMT

In qlikview I can get timestamp in milliseconds, by setting timestamp format as :-

SET TimestampFormat='MM/DD/YYYY hh:mm:ss.fff';

I want to know if there is a way to get time stamp in qlikview upto microseconds.

Re: How to format Qlikview Timestamp upto microseconds?

Mon, 09 Mar 2015 10:01:30 GMT

Hi All,

I got the solution to this courtsey User ralfbecher - Stack Overflow.

Formula to optain microseconds from TimeField:

((frac(TimeField) * 86400000) - floor(frac(TimeField) * 86400000)) * 1000 as Micro

And I would use this formula for formatting:

Timestamp(TimeField - (Micro/86400000000)) & Num(floor(Micro), '000') as TimeStamp

Here is the link to original solution :-