topic Re: Chart Dimension Convert Month to Words in QlikView

Chart Dimension Convert Month to Words

Thu, 24 Oct 2013 02:35:08 GMT

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'))

Re: Chart Dimension Convert Month to Words

jagan — Thu, 24 Oct 2013 03:05:18 GMT

Hi,

Try like this

=Pick(Num(MonthDimensionName), 'Jan', 'Feb', 'Mar', ......................, 'Dec')

Hope this helps you.

Regards,

Jagan.

Re: Chart Dimension Convert Month to Words

Thu, 24 Oct 2013 03:07:57 GMT

Where should i type this in?

Re: Chart Dimension Convert Month to Words

jagan — Thu, 24 Oct 2013 03:13:27 GMT

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.

Re: Chart Dimension Convert Month to Words

Thu, 24 Oct 2013 03:34:05 GMT

Ok.. But how do i sort the month from Jan ... Dec

Re: Chart Dimension Convert Month to Words

jagan — Thu, 24 Oct 2013 03:40:27 GMT

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.

Re: Chart Dimension Convert Month to Words

jagan — Thu, 24 Oct 2013 07:52:49 GMT

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.