Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an Excel file that I want to load but the Time column looks as below-
How can I get the hour format out of it by using Qlik script?
Thanks
maybe time(count_time/(24*3600))
(1 day = 1 unit; 24*3600 seconds in a day)
It worked! thanks 🙂