topic Re: Exlude Friday & Saturday in QlikView

Exlude Friday & Saturday

Wed, 20 Mar 2013 14:29:32 GMT

Hi,

How to exclude Friday and Saturday weekday.

Suppose I have the Date from Start Date - 01/01/2013 to End Date - 31/03/2013.

Note : I want the count of day including Saturday and Sunday.

Thanks & Regards,

Amit Kumar

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 14:32:17 GMT

weekday(date) gives you the number of the day in the week from 0 to 6.

Just exlude 4 and 5 (friday, saturday) from your query

regards

chris

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 14:44:27 GMT

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 14:45:05 GMT

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 14:45:18 GMT

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 14:57:48 GMT

Vessel Depart	Final BL
27-01-13	31-03-13

I want only exlude friday and Saturday between these dates by any function / variable.

Regards,

Amit Kumar

Re: Exlude Friday & Saturday

jagan — Wed, 20 Mar 2013 15:42:26 GMT

Hi,

Arrive one flag for this in Script and use that in expression

LOAD

DateFieldName,

If(WeekDay(DateFieldName) = 'Fri' OR WeekDay(DateFieldName) = 'Sat', 1, 0) AS WeekEndFlag

FROM DataSource;

Now in set analysis expression use

=Count({<WeekEndFlag = {1}>} DateFieldName)

Hope this helps you.

Regards,

Jagan.

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 18:44:45 GMT

Sorry It will not work, Because, I want to calculate no. of days between to dates Fields excluding Friday and Saturday.

For Example :

You are going for trip: U started on 01-01-2013 (Start Date) and U reached u'r destination after 5 Months i.e - 31-05-2013 (End Date). Now I want no. of days excluding Friday and Saturday between these months, because it was weekend for u.

Regards,

Amit Kumar

Re: Exlude Friday & Saturday

Wed, 20 Mar 2013 18:45:09 GMT

Sorry It will not work, Because, I want to calculate no. of days between to dates Fields excluding Friday and Saturday.

For Example :

Regards,

Amit Kumar

Re: Exlude Friday & Saturday

MayilVahanan — Wed, 20 Mar 2013 19:11:38 GMT

Try like this with Mr.Jagan Suggestion

=Count({<WeekEndFlag = {0}>} DateFieldName)

Hope it helps

Re: Exlude Friday & Saturday

rbecher — Wed, 20 Mar 2013 19:57:05 GMT

Hi Amit,

maybe this helps: shift the start and end date (consider Friday and Saturday as Weekend)

= networkdays(StartDate +1, EndDate +1)

- Ralf