Discussion board where members can get started with Qlik Sense.
I am using the following syntax to order the month because we run from September to September
I am creating the week number using the following syntax
Right(WeekName(DATE(Date#(Date,'DD MMMM YYYY'))),2) As "Week"
I want to do the same with the week number by starting at month 9 or week 36.
Is there a better way of ordering the week number than the way I have ordered the month ?
Any help appreciated.
Do you have a master calendar implemented?
You actually have a Week() function that will give you the week number of the date which I would look into if I was you. Maybe a combination of a Week-Year Field.