Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to how i calculate total OT hour multiplication OTRate = Total OT Amount in Qlikview.
LOAD dtAttendDateTime,
StrFactoryShortName,
StrDepartmentName,
CategoryName,
StrEmpName,
StrDesignationName,
InTime,
OutTime,
GrossSalary,
OTRate,
onDuty,
OT,
Time(OT)*24 * OTRate
FROM
[Overtime Calculation.xls]
(biff, embedded labels, table is Sheet1$);
Thank's
Hi,
Try this
Data:
LOAD *,
interval(if(Check, rangemax(0,Time-3/8),0)) as OverTime,
interval(rangemin(3/8,Time)) as RegularTime;
LOAD *, interval(frac(OutTime) - frac(InTime)) as Time;
LOAD
*
FROM
[OvertimeCalc.xlsx]
(ooxml, embedded labels, table is TB01);
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
Regards
Dhruv
If your queries are resolved, please close the thread