Working hours on weekend

[capriconuser]

I am trying to extract zoho data in qlikview. 

here i am trying to extract those users working hours who worked on weekend 

so in zoho total hours is this for 3-nov-2018 date

i am trying to calculate same in qlikview 

i do this 

SUM(If(Week_Day = 'Sat' or Week_Day = 'Sun',timestamp(WorkingHours)))

but this shows me these hours 

[capriconuser]

I have this data

TotalHours	To_Date	ToTime	WorkingHours	BreakTime	InputType	From_Date	FromTime
7:30	11/3/2018	16:31:02	7:30	0:00	7	11/3/2018	9:00:24
7:30	11/3/2018	16:31:02	7:30	0:00	7	11/3/2018	9:00:24

[jaibau1993]

Hi!

Your sum equals 15 because you have two identical rows with 7.5 workingHours. Thus, 

SUM(If(Week_Day = 'Sat' or Week_Day = 'Sun',timestamp(WorkingHours))) = 7.5 + 7.5 = 15

You should clean your data during the reload (try with "LOAD Distinct ...")

Regards,

Jaime. 

[Brett_Bleess]

Did Jaime's post help you resolve your issue?  If so, be sure to return to the thread and use the Accept as Solution button on their post to give them credit for the help and to let the other Community Members know that was the issue.  If you figured something else out, please consider posting the issue and then mark that as the solution....

Regards,
Brett