Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Working hours according to weekend

hi 

 

i am trying to get total work hours on weekend .. and i am getting wrong result. in excel i manually check this return me result 128 where currenlty dashboard shows me wrong result which is 815.. 

 

i am trying this expression 

If(WeekDay(Attendance.AttendanceDay) = 'Sat' or WeekDay(Attendance.AttendanceDay) = 'Sun',Attendance.AttendanceDay,SUM(Attendance.WorkingHours))

kindly check dashboard and excel file 

 

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try this:

SUM(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))

View solution in original post

4 Replies
tresesco
MVP
MVP

Try this:

SUM(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))

jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

Please, dont duplicate posts. As I said in the other one, try

Sum({<AttendanceDay = {"=WeekDay(AttendanceDay)>=5"}>}WorkingHours)

Jaime.

lironbaram
Partner - Master III
Partner - Master III

hi 

this expression should work for you 

sum(If(WeekDay(AttendanceDay) = 'Sat' or WeekDay(AttendanceDay) = 'Sun',WorkingHours))
capriconuser
Creator
Creator
Author

but your answer did not show me correct results..