topic Re: Working hours according to weekend in QlikView

Working hours according to weekend

capriconuser — Sat, 16 Nov 2024 19:37:34 GMT

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

Re: Working hours according to weekend

tresB — Thu, 21 Nov 2019 08:04:26 GMT

Try this:

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

Re: Working hours according to weekend

jaibau1993 — Thu, 21 Nov 2019 08:05:59 GMT

Hi!

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

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

Jaime.

Re: Working hours according to weekend

lironbaram — Thu, 21 Nov 2019 08:12:08 GMT

this expression should work for you

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

Re: Working hours according to weekend

capriconuser — Thu, 21 Nov 2019 08:21:37 GMT

but your answer did not show me correct results..