I'm not sure if you could use sorting-expressions within qlik sense but if and you have connected various period-fields (maybe within a master-calendar, here you find many informations about this approach: How to use - Master-Calendar and Date-Values) you could use something like avg(YourDateField). Otherwise you need to create a dual-field:
Syntax is: dual(StringValue, NumericValue) and in your case maybe this one:
dual(YourQuarterField, Year * 10 + NumericQuarter)
or if you hadn't such one
dual(YourQuarterField, Year * 10 + ceil(num(month(YourDateField)) / 3))
Thanks you for replying so quickly. I should have clarified that my date information is formed as a single record in my Excel dump. Columns name is Quarter and each row is represented in the form of Q1 2015. When I try your example in a load script it errors out stating that Year is not found.
I'm new to scripting so most of this is trial and error for me at this stage. Here is my original script if that sheds any light on what I am attempting.
(ooxml, embedded labels, table is Usage);
In this case you needs to split your quarter-field with string-functions like in this example:
dual(Quarter, num(mid(Quarter, 4)) * 10 + num(mid(Quarter, 2, 1))) as Quarter
and you could generate a date,too:
makedate(num(mid(Quarter, 4)), num(mid(Quarter, 2, 1)) * 3 - 2) as Date // first date in quarter