1 Reply Latest reply: Feb 7, 2017 4:46 AM by Ali Ahmad RSS

    Ordering Weeks QlikSense

    Christopher Ellis

      I am using the following syntax to order the month because we run from September to September

       

      Match([Month Field],'Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug')

       

      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.

       

      Chris