Expression Help

[abhaysingh]

Hi All,

My Calendar contain

Fiscal Year

2011-2012,

2012-2013,

2013-2014,

2014-2015

i want the output like

11-12

12-13,

13-14

14-15

evaluating FY by yearname(Date,0,4) as F_Year.

How i can do this??

Thanks

Abhay

[jonathandienst]

This should do it:

Replace(YearName(Date, 0, 4), '20', '') as F_Year

[abhaysingh]

Hi Janathan,

What if My data contain 1999-2000, than in that case it will become harcoded..

thanks

abhay

[svenkita · Accepted solution]

in the script where the fiscal year is generated you can add the following

Left Join
Load [Fiscal Year],

         Mid([Fiscal Year],3,2) & '-' & Mid([Fiscal Year],8,2) as FormatedFiscalYear

Resident <TableName>

[qlikmsg4u]

Hi Try this

load *,Right(SubField([Fiscal Year],'-',1),2)&'-'&Right(SubField([Fiscal Year],'-',2),2) as [New Fiscal Year];

load * inline [

Fiscal Year

2011-2012

2012-2013

2013-2014

2014-2015

]

[jsingh71]

Use This:

Right(SubField([Fiscal Year],'-',1),2) & '-' & Right(SubField([Fiscal Year],'-',2),2)

[#7]

Try this. Considering only four digit years.

=Mid(YearName(Date,0,4),3,3)&Right(YearName(Date,0,4),2)

Regards,

KKR