topic Re: Calendar Issue in QlikView

Calendar Issue

kamalqlik — Mon, 28 Jul 2014 08:53:52 GMT

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

Re: Calendar Issue

MK_QSL — Mon, 28 Jul 2014 08:55:16 GMT

may be this would be helpful

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

Re: Calendar Issue

kamalqlik — Mon, 28 Jul 2014 09:18:21 GMT

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

Re: Calendar Issue

qlikpahadi07 — Mon, 28 Jul 2014 11:45:55 GMT

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

Re: Re: Calendar Issue

qlikpahadi07 — Mon, 28 Jul 2014 18:18:52 GMT

Dear Kamal,

let me know if this is helpful

cheers !!!