Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have month in my chart dimension. The data in the database for month is in '01','02','03'....
How do i convert it to words when it display in chart
I know the following formula. But how could i apply it in this instance?
upper(date(Today(),'MMMM'))
Hi,
Try like this
=Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec')
Hope this helps you.
Regards,
Jagan.
Where should i type this in?
Hi,
Put this wherever you need like in expression, dimension script, but it is better to have this in script like this
LOAD
*,
Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec') AS MonthName
FROM DataSource;
Now use MonthName in Dimension or Expreesion.
Hope this helps you. If not understanding please attach sample file.
Regards,
Jagan.
Ok.. But how do i sort the month from Jan ... Dec
HI,
Then try like this
TableName:
LOAD
*,
Dual(Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec'), Num(MonthDimensionName)) AS MonthName
FROM DataSource;
Now in Sort tab select Numeric.
TableName:
LOAD
*,
Date(MakeDate(2013, Num(MonthDimensionName)), 'MMM') AS MonthName
FROM DataSource;
Now in Sort tab select Numeric.
Hope this helps you.
Regards,
Jagan.
Hi,
Please close the discussion if your issue is solved by giving the Correct and Helpful answers to the posts. It helps others to find the solution for similar issues.
Regards,
Jagan.