Converting text like "Apr" to sortable month field
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?