Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
neapicture
Contributor III
Contributor III

NetWorkDays - display per month without regard to the month selection

Hello ,

I would like to calculate an average value per working day from a filtered quantity of processed tasks (einheiten ) and display it as a diagram per month.

However, if I select the month of June as a selection field in the dashboard, for example, the formula "Month =" is not considered. So far so good. But how do I change the formula that it works with the "NetWorkDays" part - so the month selection is not taken into account. Only the selected one is shown to me here. 

 

=if(
vorgang_k='I'or vorgang_k='b' or vorgang_k='A' or vorgang_k='L','',
(
sum({$<Monat= , projekt_name= {"1401118*"},Linepool_Kategorie= {"L3 Umzüge / LW"} >}einheiten)

-sum({$<Monat= , vorgang_name={"*Wiedervorlage LS 3*","*Weiterleitung an EINS LS 3*"} >}einheiten)
)
)
/
(
NetWorkDays(monthstart([Eindeutiger Monat]),RangeMin(MonthEnd([Eindeutiger Monat]),Today()),
'2020-01-01','2020-04-10','2020-04-13','2020-05-01','2020-05-21','2020-06-01','2020-10-03','2020-11-18','2020-10-31','2020-12-25','2020-12-26','2020-12-24','2020-12-31')

)

 

1 Reply
Brett_Bleess
Former Employee
Former Employee

Hopefully one of the following may have what you need to help:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

The other link I was going to add is at the bottom of the above post, so not going to clutter things up, have a look at this and see if that may get you what you needed.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.