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

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
Partner

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
Partner

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