need help in datamodelling

[qlikapple]

Hi all,

I have one table of change order which is in epoch format,

Load * inline

CRNO,Starttime,Endtime,CI

1,1538352000,1538353000,Keyboad

2,1538352000,1538353000,Mouse

3,1538352000,1538353000,laptop

Now my requirement is for CRNO i need the daterange in minutes to calculate

[pablolabbe]

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

Thanks, Pablo 

[RudyK]

Hi,

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 Datarange
Inline [
CRNO,Starttime,Endtime,CI
1,1538352000,1538353000,Keyboad
2,1538352000,1538353000,Mouse
3,1538352000,1538353000,laptop
];

Perhaps it will help.

RudyK