Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
08748190
Contributor II
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.

0 Replies