Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

time between meetings

Hiya

i have a calculation that works out the time in days it takes for the start of the project date discussion, to the first board project meeting.

using e.g sum(Project Board Meeting Date) - Sum(Project Discussion Date)....e.g gives me 16 days.

after the board meeting, there are followup meetings.

i wish to calculate the number of days between these follow up meetings, until the project ID is over

please help

1 Reply
philip_doyne
Contributor II

Re: time between meetings

Dear Joanna

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

Email : philip.doyne@qlickit.co.uk| Office : 01709 300230 | Mobile : 07930 401440 | Web : www.qlickit.co.uk<http://www.qlickit.co.uk/>

<applewebdata://B7DDA743-0DCD-46FA-ABDE-FCF7C4CB15EE/qlickit.co.uk>

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.

[cidSmiley Very Happy4BD5D9E-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>