Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Contributor III
Contributor III

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
Contributor III
Contributor III

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