how do I change YearMonth (201105) or Month (5) from a numeric to a text value?
I'm trying to do it in the following expression
Try something like this (un-tested):
You could also try Date(Date#(YearMonth,'YYYYMM')) for YearMonth, the Date# function is used to tell QlikView the current format of the value and Date (without #) to format it in another way.
Retrieving data ...