Number as text

[#1]

Hi,

I have a few tables representing month as numbers 0, 1, 2 ... to 12. I no want to change the display of these numbers to text; Jan, Feb, March ... and so on. How do I do this?

Cheers,

Nils

[#2]

tnx for all the tips, but so far nothing has worked for me. i have attached a sample file here with some of your sample codes in it. please have a look.

[#3]

Hey Nils,

Did you try this ?

Use the dual(s, n) datatype while loading.

Like:

load dual(Montname_String, Month_Number) as Month inline

[Montname_String, Month_Number

Jan, 1

Feb, 2

....

etc.

There you can load a Stringvalue with an attached double or int value.

QV displays the string value but you can calculate or do whatever you want to do withe the number.

Check the Reference Manueal for more Information.

Hope it helps.

Greetings Flo

[saumyashah90]

Reload this qvw, you will get your answer

[saumyashah90]

Nils, that was the idea which i showed you and not the actual code,

I have attached qvw

[rustyfishbones · Accepted solution]

Nils,

Just add the Expression in your list box instaed of selecting Month

see attached

Regards

Alan

[Anonymous]

Alan

Yup that works perfectly.

Nils

Alan's qvw works, please check it.

Best Regards,     Bill

[#8]

Hi Nils,

Try in this way ,it may works for you.

Regards,

Vijay

[#9]

thank you alan, this works!

one question though: i can see in your code that you used 2013 as a reference year; is this going to affect only the 2013 years? i have other years that i need it to work for as well...