topic Re: Load only weekdays in QlikView

Load only weekdays

Anonymous — Wed, 20 Mar 2013 13:37:01 GMT

Hi,

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.

Kind Regards

Dreamer78692

Re: Load only weekdays

Gysbert_Wassenaar — Wed, 20 Mar 2013 13:40:10 GMT

Try this:

LOAD Date, Name, Value

WHERE Weekday(Date) <5 ;

Re: Load only weekdays

Anonymous — Wed, 20 Mar 2013 13:57:37 GMT

Hi,

I tried that but for some reason Monday is also not getting loaded.

Kind Regards

Dreamer78692

Re: Load only weekdays

MayilVahanan — Wed, 20 Mar 2013 14:30:53 GMT

LOAD Date, Name, Value

WHERE Wildmatch(Weekday(Date),'mon','tue','wed','thu','fri');

Hope it helps

Re: Load only weekdays

Anonymous — Wed, 20 Mar 2013 15:21:35 GMT

Hi,

Try:

LOAD

Date, Name, Value

WHERE

Weekday(Date)<>'sat.' AND Weekday(Date)<>'sun.' ;

(check before that your DayNames is 'sat.' for saturday and 'sun.' for sunday)

Re: Load only weekdays

jagan — Wed, 20 Mar 2013 15:44:11 GMT

Hi,

Try like this

LOAD

DateFieldName,

FROM DataSource

WHERE WeekDay(DateFieldName) <> 'Sat' OR WeekDay(DateFieldName) = 'Sun';

Hope this helps you.

Regards,

Jagan.

Re: Load only weekdays

vivientexier — Wed, 20 Mar 2013 16:13:33 GMT

A clean way to do this is to use NetWorkDaysDate() function.

LOAD

Date

, Name

, Value

WHERE NetWorkDaysDate(Date, Date) = 1

;