How to format Qlikview Timestamp upto microseconds?

[#1]

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.

[#2 · Accepted solution]

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 :-

Qlikview Timestamp formatting upto microseconds? - Stack Overflow