Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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))

View solution in original post

jaibau1993
Partner
Partner

Hi!

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

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

Jaime.

lironbaram
Partner
Partner

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..