Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
petrushkinandre
Contributor
Contributor

Work with a calendar (working days and holidays)

Hello.

Please suggest a solution to the issue.

I will briefly describe the question. It is necessary when choosing the name filter (Task), to get the correct value by the deadlines for the task, namely the deadline for the task in working days.

In the example, when choosing the filter "task1", which has start_date = 01/13/2017 and finish_date = 01/18/2017. It is necessary to calculate the difference between these dates, taking into account the days off.

The "Calendar" table has 2 fields, Data and Id_status (field value = 0 is the weekend; 1 is working days).

In the attachment screenshots + archive with the application file * .qvf and table in * .xlsx

Thanks in advance.

0 Replies