QlikView has a really cool data type called "Dual". This type allows you to mix text and numeric values which can be very useful.
For example, imagine that you had some pieces of text, say:
Apr, Aug, Dec, Feb, Jan, Jul, Jun, Mar, May, Nov, Oct, Sep
And you would prefer to have them sorted in another order, say:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
Then we could load this something like:
Dual(Name, Num) As Month;
LOAD * INLINE [
And the Month field would be sorted in the correct order.
If we need to get the component values spearately out of a Dual value, we can use Num and Text:
Text(Month) & ' (' & Num(Month) & ')'
Might give us a result of: