Order by Month

[nickmarlborough]

I have a column called Date flowing in from an Excel File in the Format ‘August, 2023’. I also have a column titled Week in the format ‘31’

i am trying to get the date into date format so I can sort it by date in QlikSense. In the load editor how would I do this? 

[vamshi2i]

Hi Nickmarlborough,

try this:

LOAD
Date,
Week,
Date#(Date, 'MMMM, YYYY') as FormattedDate, // Convert Date to a date format
Num(Week) as FormattedWeek // Convert Week to numeric format
FROM [your_excel_file.xlsx]
(ooxml, embedded labels, table is YourTable);

After reloading the data, you should have a new column "FormattedDate" with the dates in the correct date format, and the "Week" column should now be in numeric format. Both of these columns will allow you to sort the data correctly.

[Aurelien_Martinez]

Hi,

You can create a Date based on your year and week like :

MakeWeekDate(Right(Date, 4), Week) as Date