Data modification at Script level

[hkg_qlik]

Hi,

I am extracting data directly from a Data Warehouse. There is table for Time_Dimension which I am using.

The Time_Dimension data contains months in numeric / integer. For Example: 1, 2, 3,4,.....12.

Now I want to display 1 as JAN , 2 as FEB ........12 as DEC.

Please Advise!!

Thanks,

H

[hector]

hi

If your monthnames variable is right, use something like

month(makedate(2011,your_month_field)) as MonthName

if you have a year field, use this version

month(makedate(your_year_field,yourmonthfield)) as MonthName

OR

Create an INLINE table with the names

Load * INLINE [ Month_Num, Month_Name
1, JAN
2, FEB....];

OR use

pick(your_month_field, 'JAN','FEB','MAR'.......'DIC')

rgds