First, make sure the field is loading properly and that the results are as expected (numbers with or without leading blanks or zeroes, text trimmed both left and right...) I'd suggest you to check that doing the following if the "manad" field is text when loading
Trim(manad) as manad,
And the following if it's a number
Num(manad) as manad
Hope this helps.
"manad" in the database is a string variable.
In the database it looks like:
Since it's sorting alphabetical...how do i make it sort it sort in a correct way like: jan, feb, march, april, may....
My qvw file can be downloded from here:
Try this code
LOAD * INLINE [
Month(MakeDate(ar,ApplyMap('MapMonth',manad),dag)) as manad,
SQL SELECT ar,