topic weekday without weekend in QlikView

weekday without weekend

Anonymous — Mon, 12 Dec 2011 10:12:30 GMT

I have a dimension in a chart that shows all the weekdays, hence, my dimesion is an expression weekday(Date).

But, i only want to display the workdays (Monday, Tuesday, Wednesday, Thursday , Friday). So exlude Saturday and Sunday.

What to do?

//A.

Re: weekday without weekend

swuehl — Mon, 12 Dec 2011 10:50:30 GMT

Try maybe

=if(weekday(Date)<5, weekday(Date) )

as calculated dimension.

Re: weekday without weekend

jagan — Mon, 12 Dec 2011 11:15:52 GMT

Hi,

Weekday(Date) returns week in characters like Mon/Tue/Wed etc.

So, use this in you Dimension

=If(WeekDay(Date) * 1 < 5, WeekDay(Date) )

As WeekDay(Date) * 1 return numeric week number like 0,1,2,..

Hope this helps you.

Regards,

Jagan.

weekday without weekend

swuehl — Mon, 12 Dec 2011 11:49:48 GMT

Well, the Help says about weekday() function:

weekday ( date )

Week day. Returns an integer between 0-6.

I personally believe it will return a dual, though. Anyway, my above line just works as is for me, limiting the weekdays to Mon-Fri only and displaying the dimension value as text, not numbers.

weekday without weekend

jagan — Mon, 12 Dec 2011 11:55:02 GMT

Hi,

Yes, you are correct, but when checked this

=WeekDay(Today()) in Text object it is displaying Mon. then

I tried =WeekDay(Today())*1, it works fine.

I am currently using QV 9.0 SR2, I don't know whether it is fixed in future versions.

Regards,

Jagan.

topic weekday without weekend in QlikView

weekday without weekend

Re: weekday without weekend

Re: weekday without weekend

weekday without weekend

weekday( date )

weekday without weekend

weekday ( date )