Qlik Community

Qlik Sense App Development

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

08748190
New Contributor II

Integrate Networkdays in set analysis

Hi All,

I want to integrate the function NetWorksDays that return the difference between two dates without weekends(Sunday and Saturday) in my (regle de calcul).
in my case my regle calcul do the sum of absence of salary by loop over period of absence without count weekends .

Sans titre.png

 

Set analysis :

((Sum({$< __Intervall_Type  ={'Periode Absence'},__Period_Year= {'$(vyear_analyse)'}>}

[__Number_Days_Absence]))*8

How to integrate the function NetWorksDays in my regle calcul ?

thank you in advance.