topic Re: Working hours on weekend in QlikView

Working hours on weekend

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

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

Re: Working hours on weekend

capriconuser — Wed, 08 Jan 2020 07:00:59 GMT

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

Re: Working hours on weekend

jaibau1993 — Wed, 08 Jan 2020 07:49:37 GMT

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.

Re: Working hours on weekend

Brett_Bleess — Wed, 05 Feb 2020 21:03:08 GMT

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