topic Re: help needed in changing weekstart in QlikView

help needed in changing weekstart

fashid — Thu, 27 Mar 2014 06:11:59 GMT

I have been provided with an inline table in which every new week starts from Monday and the corresponding date,

I have been told to make the week start from Friday instead of Monday.

I am attaching a qvw file for your reference any help is greatly appreciated i am a new to qlikview and learning slowly

Re: help needed in changing weekstart

CELAMBARASAN — Thu, 27 Mar 2014 06:25:30 GMT

Expecting like this?

weekdaytable:

LOAD *,

if(IsNull(Previous(Date)), 1, if(WeekStart(Previous(Date), 0, 4) = WeekStart(Date, 0, 4), Peek('WeekNo'), Peek('WeekNo') + 1)) AS WeekNo;

Load

day(Date) as Day,

Date,

WeekDay(Date) as weekday,

RowNo() as count

Resident Input;

Re: help needed in changing weekstart

tresB — Thu, 27 Mar 2014 06:31:16 GMT

Read these blogs:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/21/week-start

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers

Re: help needed in changing weekstart

mangalsk — Thu, 27 Mar 2014 06:32:54 GMT

Hello,

Find attachment its working.

Hope it help you

Find field NewWeekStartDate

Re: help needed in changing weekstart

jjordaan — Thu, 27 Mar 2014 06:39:31 GMT

Hi Nadeem,

You do this within the script of your Master Calendar

Dual(WeekDay(Field),Mod(WeekDay(Field)+3,7))

Re: help needed in changing weekstart

fashid — Thu, 27 Mar 2014 09:28:44 GMT

Actally i dont have master calendar i am told to do this just with the inline table

Thanks for the Input

Re: help needed in changing weekstart

fashid — Thu, 27 Mar 2014 09:33:27 GMT

Thanks a lot u nailed it perfectly ... If you could explain me the IF statement that you have used and also why you have not included the from statement in your first load statement

"LOAD *,

if(IsNull(Previous(Date)), 1, if(WeekStart(Previous(Date), 0, 4) = WeekStart(Date, 0, 4), Peek('WeekNo'), Peek('WeekNo') + 1)) AS WeekNo;"

i would greatly appreciate it..

Thanks & regards,

Nadeem