Monthname for Fiscal Year in the chart

[arunqlik2view]

Hi All,

I need help in creating the Fiscal Month Name for the Dimenions in the chart. Currently , I use below function but it  gives me only the numbers as 1 to 12 but instead I want the charts to display the months starting  from Apr, May, ---- Till March.

SET vFM = 4;

Load *,

Mod(Month-$(vFM), 12)+1 as fMonth;

My Current Output : -

please help me to fix this.

Thanks in Advance,

Arun

[fvelascog72]

Hi,

Try with this:

Fiscal Year

Saludos

[sunilkumarqv]

  try creating preceding load like below script and change dimension fMonth to FMonth

SET vFM = 4;

Load * , Dual(Month, fMonth) as FMonth;

Load *,

Mod(Month-$(vFM), 12)+1 as fMonth ,

[arunqlik2view]

I did get error for fMonth , but got it fixed . Thanks for the quick response.

[arunqlik2view]

Thanks for the quick response.