Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
iswarya
Partner - Creator
Partner - Creator

network days

The expected day is calculated as: networkdays(startdate,duedate) and actual days as: networkdays(startdate,finalcompdate)

but for same start day and finalcompdate i want the expected and actual days as 1. but for first few values i am getting 0

PFA

1 Reply
marcus_sommer
MVP
MVP

I think you need to adjust the result manually maybe just with + 1 if you want to display a different logic. Further it looked that you don't use dates instead of timestamps and you may change this, too - for example with: date(floor(YourTimestamp)).

- Marcus