Data modification at Script level

hkg_qlik — Thu, 13 Jan 2011 19:49:06 GMT

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,

hector — Thu, 13 Jan 2011 19:56:01 GMT

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

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

topic Data modification at Script level in QlikView