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

Extract weekend days from date

hi all 

i have this date field and from that to extract only sat and sun.. which is weekend.. how i extract weekend from date.. 

 

data link 

https://www.dropbox.com/s/xaps82qyyo6i0fa/ar.xlsx?dl=0

5 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

If you want to keep only weekend days, then write something like

Load

        [Fields]

from [Excel]

where WeekDay(AttendanceDay) >= 5

Regards,

Jaime.

Victor_Alumanah
Creator
Creator

=Sum({<AttendanceDay = {'Sat','Sun'}>}WorkingHours)

While we teach we learn
capriconuser
Creator
Creator
Author

there is only  dates in date field .. have you checked sheet ? 

@Victor_Alumanah 

jaibau1993
Partner - Creator III
Partner - Creator III

Hi

If you need it in an expression the use

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

(i thought you needed it in script side)

Regards,

Jaime.

Victor_Alumanah
Creator
Creator

Sorry I seemed to have only pasted in part of the solution I had and now I can not seem to find where I saved it, the solution @jaibau1993 will give you Sat and Sun.

While we teach we learn