Calendar Issue

[kamalqlik]

Hi I want the Week in the format as given below.

ie...Week will depend on Thrusday ie if Thrusday is on 7/31/2014 than the week will lie in the same month as on july.

In case it is on 9/4/2014 than it will lie in sep and the week will also lie in sep.

Date	Day	Defined Week	Calculated Week	Week will exist   in Month     (Based on Thursday)
7/27/2014	Sunday	20140730	201430	Jul-14
7/28/2014	Monday	20140730	201430	Jul-14
7/29/2014	Tuesday	20140730	201430	Jul-14
7/30/2014	Wednesday	20140730	201430	Jul-14
7/31/2014	Thursday	20140730	201430	Jul-14
8/1/2014	Friday	20140830	201430	Jul-14
8/2/2014	Saturday	20140830	201430	Jul-14
8/31/2014	Sunday	20140835	201435	14-Sep
9/1/2014	Monday	20140935	201435	14-Sep
9/2/2014	Tuesday	20140935	201435	14-Sep
9/3/2014	Wednesday	20140935	201435	14-Sep
9/4/2014	Thursday	20140935	201435	14-Sep
9/5/2014	Friday	20140935	201435	14-Sep
9/6/2014	Saturday	20140935	201435	14-Sep

Regards

Kamal

[MK_QSL]

may be this would be helpful

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

[kamalqlik]

Hi Manish,

That will be the solution for weekstart.

My question is on Thrusday when it appear at last.

Than that week will be considered with thrusday.Otherwise it will be same

[qlikpahadi07]

Dear Kamal,

pardon me I am not getting the issue correctly but it seems you need some RND across Calendar,

well I can suggest you to create a Inline table with Date and NEW_Month mapped with Date field with your database. Manually you can change numbers as desired with your logic mentioned above ("Week will exist in Month" based on Thursday)

and  NEW_Month column will be your output.

as laymen just create a INLINE Master calendar as per your desired output for 10 Years and use it with your Data Model.

Cheers!!!

might be helpful

[qlikpahadi07 · Accepted solution]

Dear Kamal,

let me know if this is helpful

cheers !!!