topic Re: need help in converting SQL to QlikView in QlikView

need help in converting SQL to QlikView

Tue, 28 Apr 2015 14:28:07 GMT

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.

Re: need help in converting SQL to QlikView

rubenmarin — Tue, 28 Apr 2015 14:33:33 GMT

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]...

Re: need help in converting SQL to QlikView

ramoncova06 — Tue, 28 Apr 2015 14:34:23 GMT

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

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