Discussion Board for collaboration related to QlikView App Development.
I need your help
I have to count the difference between two dates without counting the sundays
Any idea please ?
May be look here:
Networkdays with saturday
Calculate weeks and days in QlikView | Qlik Community
i see that the solution is to create a function, how to do that please?
Function is give by Gysbert in that link
Function GetWorkDays(StartDate, EndDate)
dCount = 0
For dt = StartDate To EndDate
If WeekDay(dt) <> 1 Then
dCount = dCount + 1
GetWorkDays = dCount
Use SET on top, something like this
below example is Not your case:
SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);