Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I want to calculate the performance of my bussiness by timing
I use the networkday but I got a lot of challenge when use this function:
- Networkday un-count Saturday -> so how can I count Saturday with this function or another fomular it's ok?
- I want to count how many working day from first day of month up today without Sunday & holiday (Month to date)
- And the same with Year to date -> how many working day from first day of year up today (Year to date)
I had been reference with a lot of topic in this community but it's not work!
I am very appreciate your support!
Phung Nguyen
Perhaps this document helps: Find Net Working Days
Thanks gwassenaar
I had been tried with this solution, but It's use for count day left, I want to count how many day up to now!
Do you have any solution for that case.
Best regards,
Phung Nguyen
Hi Phung,
I found this blog on how to master 'Point in Time' reporting with Set Analysis really useful (refer to it every time I work with calendars).
The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.
Really effective way of handling MTD, YTD and all other possible combinations.
Enjoy.
PVS