Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samiboyvn
Contributor III
Contributor III

Calculate performance by time (Year to date - YTD, Month to date - MTD)

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

3 Replies
Gysbert_Wassenaar

Perhaps this document helps: Find Net Working Days


talk is cheap, supply exceeds demand
samiboyvn
Contributor III
Contributor III
Author

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

PaulVanSiclen
Employee
Employee

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