Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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..