Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Trim Year

I have an expression where I am combining Month & Year  (=Month&'-'&Year) which creates Jan-2011.

How would I trim the year to display like Jan-11  (Just display the last two characters)

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use

          (=Month&'-'&Right(Year,2))

Hope it helps

Celambarasan

View solution in original post

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use

          (=Month&'-'&Right(Year,2))

Hope it helps

Celambarasan