Discussion Board for collaboration on QlikView Scripting.
I have the following script
LOAD Date, Name, Value
WHERE Weekday(Date) = true ;
I only want the dates that occurs on weekdays.
Any assistance is appreciated.
Go to Solution.
Date, Name, Value
Weekday(Date)<>'sat.' AND Weekday(Date)<>'sun.' ;
(check before that your DayNames is 'sat.' for saturday and 'sun.' for sunday)
WHERE Weekday(Date) <5 ;
I tried that but for some reason Monday is also not getting loaded.
Hope it helps
Try like this
WHERE WeekDay(DateFieldName) <> 'Sat' OR WeekDay(DateFieldName) = 'Sun';
Hope this helps you.
A clean way to do this is to use NetWorkDaysDate() function.
WHERE NetWorkDaysDate(Date, Date) = 1