topic Re: Substr in QlikView

Substr

Wed, 22 Apr 2015 20:20:13 GMT

Hi,

Can someone please help me with this requirement.

I have column "Invoice Tax Description" which has values like [10PT, 11TR, 12FR, 13YT, 14GH]

I want the values as 2010 or 2011 or 2012 or 2013 or 2014.

Basically I want to concatenate '20' & [first two characters of Invoice Tax Description]

I wrote my expression as ='20'&substr([Invoice Tax Description],1,2)

Thank you in advance.

Regards,

Adi

sunny_talwar — Wed, 22 Apr 2015 20:23:20 GMT

Try this may be:

=20 & Left([Invoice Tax Description], 2)

or if you want it to be actual date year use this:

=Date#(20 & Left([Invoice Tax Description], 2), 'YYYY')

Best,

Sunny

Wed, 22 Apr 2015 20:29:23 GMT

Thank you Sunny. It worked.

sunny_talwar — Wed, 22 Apr 2015 20:30:00 GMT

Awesome!