topic Re: How to create a quarter column based on week number on load script in QlikView

How to create a quarter column based on week number on load script

martin_hamilton — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to determine the quarter within which the week number sits within on a load script.

I have a list of records with a column of [week] but am struggling to get it to determine the quarter.

I have managed to convert a date to months but am struggling with this one.

thanks

martin

sunny_talwar — Fri, 26 Aug 2016 12:58:49 GMT

May be like this:

'Q' & Ceil(Month(MakeWeekYear(Year(Today()), [week]))/3) as Quarter

martin_hamilton — Fri, 26 Aug 2016 13:03:56 GMT

Hi Sunny

am receiving the error below:

Error in expression:

MAKEWEEKYEAR is not a valid function

any ideas

sunny_talwar — Fri, 26 Aug 2016 13:18:25 GMT

Apologize, the name of the function is MakeWeekDate()

'Q' & Ceil(Month(MakeWeekDate(Year(Today()), [week]))/3) as Quarter

martin_hamilton — Fri, 26 Aug 2016 13:23:46 GMT

worked a treat thank you

sunny_talwar — Fri, 26 Aug 2016 14:09:54 GMT

Awesome, if you now have got what you were looking for, please close this thread by marking correct and helpful responses.

Best,

Sunny