Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
)
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