topic Re: Days difference including holidays qlikview in QlikView

Days difference including holidays qlikview

capriconuser — Sat, 16 Nov 2024 19:38:03 GMT

HI all

here i am trying to get total days including weekend between fromdate and todate..

script

LOAD Id, LeaveType, OwnerName, Date(CreatedDate,'DD/MM/YYYY') as LeaveDate, Month(CreatedDate) as LeaveMont, Year(CreatedDate) as LeaveYear, Week(CreatedDate) as LeaveWeek, From as fromdate, To as todate FROM L_sheet.xlsx (ooxml, embedded labels, table is Le25);

this is what i am trying

networkdays (Leaves.From,Leaves.To)

but here i get days without weekend..

when i do just

(Leaves.From - Leaves.To)

then i get this

whereas i want include weekend days also ..

how i do this

Re: Days difference including holidays qlikview

mahaveerbiraj — Wed, 20 Nov 2019 10:50:04 GMT

hi try this,

fabs(FLOOR(Interval(Date(Leaves.From,'DD-MMM-YYYY') - date(Leaves.To,'DD-MMM-YYYY'),'d')))

Re: Days difference including holidays qlikview

tresB — Wed, 20 Nov 2019 10:50:24 GMT

Instead of From - To, I guess you need To - From, i.e.

(Leaves.To - Leaves.From)

Re: Days difference including holidays qlikview

capriconuser — Wed, 20 Nov 2019 10:52:35 GMT

then this shows me only negative numbers.. nothing changed

Re: Days difference including holidays qlikview

capriconuser — Wed, 20 Nov 2019 10:53:48 GMT

@tresB i mean nothing changed i still did not get whole date using this approch

leaves.to - leaves.from

Re: Days difference including holidays qlikview

capriconuser — Wed, 20 Nov 2019 10:54:44 GMT

@mahaveerbiraj still nothing changed .. still i did not get some data using this approch

Re: Days difference including holidays qlikview

tresB — Wed, 20 Nov 2019 11:07:12 GMT

If you use: =leaves.to - leaves.from

how does your output look like? Also let know your expected output.

Edit: In the meanwhile, you can try below as well:

=Interval(leaves.to - leaves.from, 'D')

Re: Days difference including holidays qlikview

capriconuser — Wed, 20 Nov 2019 11:42:27 GMT

@tresB the output which i already posted in 2nd picture in question

Re: Days difference including holidays qlikview

tresB — Wed, 20 Nov 2019 12:21:02 GMT

Try to add two more expression in your chart, like:

=leaves.to - leaves.from

and

=Interval(leaves.to - leaves.from, 'D')

and share the output (screen shot) for them. Or, try to share your sample app.