topic Re: Expression Help in QlikView

Expression Help

abhaysingh — Mon, 29 Jun 2015 05:07:50 GMT

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

Re: Expression Help

jonathandienst — Mon, 29 Jun 2015 05:12:52 GMT

This should do it:

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

Re: Expression Help

abhaysingh — Mon, 29 Jun 2015 05:14:51 GMT

Hi Janathan,

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

thanks

abhay

Re: Expression Help

svenkita — Mon, 29 Jun 2015 05:15:24 GMT

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>

Re: Expression Help

qlikmsg4u — Mon, 29 Jun 2015 05:15:36 GMT

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

]

Re: Expression Help

jsingh71 — Mon, 29 Jun 2015 05:19:18 GMT

Use This:

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

Re: Expression Help

Mon, 29 Jun 2015 05:31:20 GMT

Try this. Considering only four digit years.

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

Regards,

KKR