Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following which have been converted to time, but I need a formula in Qlik to do the same:
Action Time Converts to the following time
48240 13.24.00
48249 13.24.09
The formula is as follows with respect to the first example above:
Hour worked out as 48240/3600 = 13.4 (hour is 13)
Minutes - remainder/60 = 1440/60 = 24 (minutes is 24)
Seconds will 00 as there is no remainder
Any idea how I can incorporate the above in Qlik?
Thanks
Shamit
Hi Pooja,
Please attach your solution.
Thanks
Shamit
hi shamit,
i have loaded in script and attached you the QVW
Thanks!
Can you try this for me
LOAD *, Time(Time#([Action Time],'sssss'),'h:m:ss') as Converts to the following time INLINE [
Action Time
48240
48249
];
And take table box, With the names are [Action Time] & [Converts to the following time] and then see.