Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Contributor III
Contributor III

Days difference including holidays qlikview

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.. 

 

Capture.JPG

when i do just

 

(Leaves.From - Leaves.To) 

 

 

then i get  this 

Capture.JPG

 

whereas i want include weekend days also .. 

 

how i do this 

 

Labels (2)
8 Replies
mahaveerbiraj
Creator II
Creator II

hi try this,

 

 

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

 

tresesco
MVP
MVP

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

(Leaves.To - Leaves.From)

 

capriconuser
Contributor III
Contributor III

then this shows me only negative numbers.. nothing changed

capriconuser
Contributor III
Contributor III

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

leaves.to - leaves.from

capriconuser
Contributor III
Contributor III

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

tresesco
MVP
MVP

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'

capriconuser
Contributor III
Contributor III

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

tresesco
MVP
MVP

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.