topic Re: Working day Flag in Script in QlikView

Working day Flag in Script

satishkurra — Mon, 28 Nov 2016 19:53:27 GMT

I'm using the below expression in script to get the working days as 8 for weekdays and for weekends as 0.

If(Match(WeekDay(Date(Date#("DATE",'YYYYMMDD'),'M/D/YYYY'),0),'Sat','Sun'), 0,8) as WorkDayFlag,

This is working fine for me in desktop.

But if i run the same using QMC, the task fails and throws the below error.

Can someone help me with the same?

Thanks

Satish

MK_QSL — Mon, 28 Nov 2016 19:55:34 GMT

Try...

If(Match(WeekDay(Date#(DATE,'YYYYMMDD')),'Sat','Sun'),0,8) as WorkDayFlag

its_anandrjs — Mon, 28 Nov 2016 20:00:09 GMT

Try

LOAD

If(Match(WeekDay(Date(Date#("DATE",'YYYYMMDD'),'M/D/YYYY')),'Sat','Sun'),0,8) as WorkDayFlag

From Source;

Why you use 0 in statement

If(Match(WeekDay(Date(Date#("DATE",'YYYYMMDD'),'M/D/YYYY'),0),'Sat','Sun'), 0,8) as WorkDayFlag,

Regards

Anand

satishkurra — Mon, 28 Nov 2016 20:07:50 GMT

Hi Manish

This is working.

How come it is not throwing any error if i perform the reload in desktop and throwing error if we execute task from QMC?

Also why the expression i mentioned is not working

Thanks

Satish

satishkurra — Mon, 28 Nov 2016 20:08:37 GMT

I'm trying to force the first day as Monday. Hence used 0