2 Replies Latest reply: Jun 12, 2013 12:45 PM by Stefan Wühl RSS

    Converting text like "Apr" to sortable month field

    Michael Hassinger

      I am just not getting this to work right.

       

      I have a field that is not recognized as an actual month by QlikView because it is parsed out of a longer text field. So I have a field called month that works for selecting, but can't sort the right way (Jan, Feb, Mar, etc.).

       

      It seems I can't just use Month() on it. I've also tried various ways to use the Date() function first, but to no avail.

       

      So how do I get this text field that contains values like "Apr" to still display "Apr" to the user, but are recognized as valid months for sorting?