topic Unlike dates in days in QlikView

Unlike dates in days

warrentk80 — Tue, 20 Oct 2015 08:12:41 GMT

Goodmorning everyone,

I need to calculate a date difference in days and not solar. (thus excluding Saturdays and Sundays)

the next step I should do is to calculate the difference between two data considering also the end time working and not of 24 h.

someone would know to give me directions?

Thanks for collaboration

Andrea

Re: Unlike dates in days

ahmar811 — Tue, 20 Oct 2015 08:18:04 GMT

can you upload some simple excel or .qvw file

Re: Unlike dates in days

hic — Tue, 20 Oct 2015 08:21:24 GMT

Check the function Networkdays()

HIC

Re: Unlike dates in days

miguelbraga — Tue, 20 Oct 2015 08:25:53 GMT

Hi Andrea,

I've done something similar to this and found an interesting post on the community that you can follow to get what you need. Please check the following threads:

function:networkday

Networkdays function to change non working days from saturday-sunday to thursday-friday

NetWorkDays

Regards,

Re: Unlike dates in days

miguelbraga — Tue, 20 Oct 2015 08:35:35 GMT

You can do it using this function:

=NetWorkDays([Your Start Date], [Your End Date],$(vPublicHolidays))

Which vPublicHolidays you can assign the holydays days like the following example:

'01/01/2013','01/04/2013','06/05/2013','25/12/2013','26/08/2013','26/12/2013','27/05/2013','29/03/2013'

Hope this is what you're looking for

Re: Unlike dates in days

warrentk80 — Tue, 20 Oct 2015 08:43:38 GMT

Thanks for the answer, in the attached file. I would like to calculate difference in the script and not of the dashboard.

Available for clarification

Thank you

Andrea

Re: Unlike dates in days

miguelbraga — Tue, 20 Oct 2015 09:26:17 GMT

Check my binary qvw please: