topic Defining a (Thur - Fri) FinSalesWeek in QlikView https://community.qlik.com/t5/QlikView/Defining-a-Thur-Fri-FinSalesWeek/m-p/433099#M1152187 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I would like to know if there is a better way to define a SalesWeek that begines on Thursday and ends on the following Friday and then align it to my Financial Year (April - March) such that the first SalesWeek starts on the first Thursday of April, this becoming my 'FinSalesWeek'.</P><P></P><P>I have managed to define the SalesWeek as: Right(WeekName(D,0,-3),2) as SalesWeek, my challenge is to allign this SalesWeek to my financial year as defined above to come up with a FinSalesWeek.</P><P></P><P>As a short term solution i have defined my calendar in excel (see attached), but it complicates things when i want to pick things like the max event by date etc.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 08 Apr 2013 16:18:50 GMT 2013-04-08T16:18:50Z Defining a (Thur - Fri) FinSalesWeek https://community.qlik.com/t5/QlikView/Defining-a-Thur-Fri-FinSalesWeek/m-p/433099#M1152187 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I would like to know if there is a better way to define a SalesWeek that begines on Thursday and ends on the following Friday and then align it to my Financial Year (April - March) such that the first SalesWeek starts on the first Thursday of April, this becoming my 'FinSalesWeek'.</P><P></P><P>I have managed to define the SalesWeek as: Right(WeekName(D,0,-3),2) as SalesWeek, my challenge is to allign this SalesWeek to my financial year as defined above to come up with a FinSalesWeek.</P><P></P><P>As a short term solution i have defined my calendar in excel (see attached), but it complicates things when i want to pick things like the max event by date etc.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 08 Apr 2013 16:18:50 GMT https://community.qlik.com/t5/QlikView/Defining-a-Thur-Fri-FinSalesWeek/m-p/433099#M1152187 2013-04-08T16:18:50Z