I have a field in the following format - YYYYMM (ex: 200801) and I need monthName in the format - MMM-YYYY (ex: Jan-2008)
What I've done is this:
date(makedate(ano, num(mes, '00'), 01),'MMM YYYY') as MMMYYYY,
Pick(mes, 'jan','fev','mar','abr','mai','jun','jul','ago','set','out','nov','dez') as dsc_mes
The problem here is that the months doesn't seem to appear correctly ascending sorted. For example, in the year 2014 the months appear in the correct order, but in the year 2015 which there isn't all the possible months, the chart appear like this:
I've tryed format the field like I would do in Qlikview, but the field becomes null:
I'm afraid your post is confusing me. I see field names like MMMYYY and dsc_mes mention, but the screenshot seems to use a field mes_PCO. And that shows two-digit values that look like month numbers and not MMM-YYYY values. The description you wrote and the screenshot you posted don't make sense (no pun intended).
Did you change the sort order of the dimension at all or is it set to automatic? Perhaps you simply need disable the autormatic sorting and to set it to sort numerically.
Can you post a small qlik sense app that demonstrates the problem?