topic Re: Extract weekend days from date in QlikView

Extract weekend days from date

capriconuser — Wed, 20 Nov 2019 12:58:33 GMT

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

Re: Extract weekend days from date

jaibau1993 — Wed, 20 Nov 2019 14:18:49 GMT

Hi!

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

Load

[Fields]

from [Excel]

where WeekDay(AttendanceDay) >= 5

Regards,

Jaime.

Re: Extract weekend days from date

Victor_Alumanah — Wed, 20 Nov 2019 14:35:46 GMT

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

Re: Extract weekend days from date

capriconuser — Thu, 21 Nov 2019 05:12:14 GMT

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

@Victor_Alumanah

Re: Extract weekend days from date

jaibau1993 — Thu, 21 Nov 2019 08:00:46 GMT

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.

Re: Extract weekend days from date

Victor_Alumanah — Thu, 21 Nov 2019 09:23:30 GMT

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.