This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am new to qlikview and I am working on a logic of calculating the Turn Around Time between a date range [date/time] fields
I found code posted by Rob Wunderlich in the below thread.
Calculate hours between two Date/Time strings
Could you kindly assist by clarifying the below code lines. I have done some research on QlikView Help and here's my understanding of the below logic so far.
Line 1: The Interval() is used to return the results as time. Please correct me if I am wrong
Line 2: The RangeMin() is to limit the time to 17:00 hours. Please correct me if I am wrong
Line 3: The RangeMax() is to limit the time to 8:00 hours. Please correct me if I am wrong
Line 4: The NetWorkDays() is to return the number of days. The results is returned as time. Please correct me if I am wrong, why are we subtracting a 1 or a day???
2 (RangeMin(frac(Closedate), MakeTime(17)) -
3 RangeMax(frac(Logdate), MakeTime(8)))
4 + (NetWorkDays(Logdate, Closedate-1) * MakeTime(9)) // Only 9 hours per whole day
Business Working Hours Calculation
Thank you sir
Did perhaps you pick anything wrong in my understanding of what the code is doing in my original post?
here is is an example of NetWorkingDays:
step 1: type that in script:
Date(Date#(Datum, 'DD.MM.YYYY')) as Datum
Concat(Chr(39) & Datum & Chr(39), ',') as HolidaysDay
Let vMyHoliday = FieldValue('HolidaysDay',1);
Let vCurrentMonth = Month(Today());
Date(Date#(TurnoverDate, 'DD.MM.YYYY')) as TurnoverDate, Turnover
Month(TurnoverDate) as Month,
MonthName(TurnoverDate) as MonthYear,
if(Year(TurnoverDate) = Year(Today()) and Month(TurnoverDate) = Month(Today()),
$(vMyHoliday))) as WorkingDays
drop Table TurnoverTab, Holiday;
step 2: on UserInterface: on Chart:
create a straigh table:
Use as Dimension:MonthYear, WorkingDays,
and as Expression use: Sum(Turnover) / WorkingDays as Avg Sales
I hope that exaple helps you to understand this issue.