Dates are stored in QlikView (under the hood) as a number with decimal representing the number of days or part of a day. This facilitates what you want because if you take
31/12/2015 12:00 - 28/12/2015 00:00 you get 3.5 days
You can use the INTERVAL(FieldName,’dd:hh:mm’) to format 3.5 as 3:12:00
Basically you can add and subtract date fields as you will.
However beware – if your source data is in a format that QlikView cannot recognise as a date it will load it as TEXT and it will have a value of 0 ….:-(
Philip Doyne – Technical Director
QlickiT, Century Business Centre, Manvers, Rotherham, South Yorkshire, S63 5DA
BUSINESS INTELLIGENCE The Way IT Should Be – Bespoke As Standard
QlickiT is a Company Registered in England and Wales No: 5336031
Registered Address: Century Business Centre, Manvers, Rotherham S63 5DA
This message contains information which may be confidential and privileged. Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.
Please consider the environment before printing this email.
[cid:D4BD5D9E-B430-4008-BFE9-97E070BE01A9]<http://qlickit.co.uk/products-and-business-solutions/nprinting> <http://qlickit.co.uk/products-business-solutions/stratpro> <http://www.linkedin.com/company/qlick-it-ltd> <https://twitter.com/qlickituk>