Expression help

[abhaysingh]

I have year like 11-12, 12-13, 13-14, 14-15

I want to show it like FY 12, FY 13, FY 14, FY 15

kindly help

[tresesco]

Try like:

Load

          'FY ' &SubField(YourYearField, '-',2) as NewYear

[ashfaq_haseeb]

Hi,

Look at this post

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

Fiscal and Standard Calendar generation

regards

ASHFAQ

[abhaysingh]

can I do it on front end??

[jyothish8807]

Yes you can.

Regards

KC

[abhaysingh]

HOW?

[maxgro]

same expression of tresesco

  'FY ' &SubField(YourYearField, '-',2)

[jyothish8807]

Hi,

write this as expression in a straight chart and name it as New Year

='FY ' &SubField(YourYearField, '-',2)

Rgards

KC