Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Working hours on weekend

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

Capture.JPG

 

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 

Capture2.JPG

3 Replies
Highlighted
Contributor III
Contributor III

Re: Working hours on weekend

I have this data

 

TotalHoursTo_DateToTimeWorkingHoursBreakTimeInputTypeFrom_DateFromTime
7:3011/3/201816:31:027:300:00711/3/20189:00:24
7:3011/3/201816:31:027:300:00711/3/20189:00:24
Highlighted
Partner
Partner

Re: Working hours on weekend

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. 

Highlighted
Digital Support
Digital Support

Re: Working hours on weekend

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.