Qlik Community

QlikView Documents

Documents for QlikView related information.

need help in datamodelling

sahajaqlik
Contributor

need help in datamodelling

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

 

 

Tags (1)
Comments
Luminary
Luminary

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 

0 Likes
rudykostka
New Contributor

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

0 Likes
Version history
Revision #:
2 of 2
Last update:
‎02-20-2019 04:32 PM
Updated by:
 
Contributors