substring function

[Anonymous]

Hi  All,

     We have a requirement to display just last two digits of year. Is there any substring equillent function in Qlikview?.

Year: 2004

Need to display just :04

[eddysanchez]

The equivalent of substring is: mid

mid(Year,3,2)

Another solution is: right(Year,2)