Using Dual to handle period name sorting

QlikView does not have any data types. All data is stored as dual values, a number, and a text representation. Pure text values are still stored as dual, but just the number part is null.

A common field that is created in a QlikView script is the Month field linked to a date. This is a great example of dual because it has a number from 1 to 12, and a text representation from January to December. However, some companies, especially in their financial applications, have periods that do not start in January. For example, it is quite common for companies in the UK to have a financial year starting in April. In this recipe, we are going to create a Period field that has a period number and a matching month name that does not match the calendar year and month.

How to do it…

Use the following steps to use Dual to handle period name sorting:

1. Load the following script:

   Calendar:
   Load
     Date(TempDate) As Date,
     Year(TempDate) As Year,
     Year(YearStart(TempDate...