Documents for QlikView related information.
I have one table of change order which is in epoch format,
Load * inline
Now my requirement is for CRNO i need the daterange in minutes to calculate
Please, post questions related to the product in the correct discussion board.
Here is the list of discussion board for qlik products, https://community.qlik.com/t5/Qlik-Products/ct-p/qlik-products
This is the UNIX time format. It is the number of seconds since 1.1.1970 00:00:00.The difference between End and Start is the number of seconds and is calculated as a part of the day and converted to a time format.
Datarange:LOAD* ,Time((Endtime-Starttime)/60/60/24) as DatarangeInline [CRNO,Starttime,Endtime,CI1,1538352000,1538353000,Keyboad2,1538352000,1538353000,Mouse3,1538352000,1538353000,laptop];
Perhaps it will help.