Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

samiboyvn
New Contributor II

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

Tags (2)
3 Replies

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

Perhaps this document helps: Find Net Working Days


talk is cheap, supply exceeds demand
samiboyvn
New Contributor II

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

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

Employee
Employee

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

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