Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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