topic Re: Sum Function in QlikView

Sum Function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

When I sum worked hours of an employee for a particular month and year, I'm not getting the expected result.

Code I have used,

Hours0:

LOAD EmployeeID,

ProjectID,

ReleiveStatus,

sheet_date as Sheetdate,

worked_hours as WorkHours

Resident ResourceTimesheet;

Fact:

load Date(floor(Sheetdate),'MM/DD/YYYY') as Timesheet,

Year(Sheetdate) & '|' & Month(Sheetdate)& '|' & Date(Sheetdate) as Sheetdate,

EmployeeID,

ReleiveStatus,

If(len(WorkHours)>0,WorkHours,0) AS WorkHour

Resident Hours0;

Plz suggest a way to achieve this.

Thanks in advance.

I have attached the sample of data along with this

sunny_talwar — Tue, 30 May 2017 14:43:01 GMT

Seems like the same query as this one?

micheledenardi — Tue, 30 May 2017 14:55:01 GMT

The xls file is corrupted. Please re-upload it.

What is your expected result ?

Anonymous — Tue, 30 May 2017 15:33:22 GMT

I have replaced the file

Anonymous — Tue, 30 May 2017 15:33:34 GMT

I have replaced the file