# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## Calculate Salary by Month -Weeks

Hi everyone,

I need your help please  Actually i need to calculate the salary by Moth - weeks but the problem is that i have short weeks

for example for october 2015;

In the first week IF the date is between

Fecha_Ini       Fecha_Fin

2015-09-28    2015-10-04

the calculate is  = (Salary/7)*4

where the 4 are the working days for October between the first week what i mean is that just i take the working days of the october in the first week.

Now other example the same month we go  the last week of october what happen?

Fecha_Ini     Fecha_Fin

2015-10-26  2015-11-01

again we have Short Weeks the calcuate just only take the days of the week in october

the calculate is  = (Salary/7)*6

here the 6 are the working days for October between the last week what i mean is that just i take the working days of the october in the last week.

guys do you understand what i nedd?? please can your help me??

Thanks REGARDS!!!!!