need help in converting SQL to QlikView

[#1]

Hi how can i write the below expression in QlikView by loading the data from the excel file or QVD instead of pulling data from SQL server.

CASE WHEN DATEPART(dw, D.Calendar) IN (1,7) THEN 0 ELSE 1 END

thanks in advance.

[rubenmarin]

Hi Chinna, you can use WeekDay() to check the day, it may vary, 0 can be Monday or Sunday depending on regional settings, it should be something like:

If(match(weekday(Date), 0, 6), 0, 1) as FieldName

From [xls]...

[ramoncova06 · Accepted solution]

you could use network days for this but this would do it

if(WeekDay( D.Calendar) = 1 or WeekDay( D.Calendar) = 7, 0, 1)