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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

using timestamps

Hi

I have timestamps like this:

2013-01

2012-12

2012-11

2012-10

..........

2012-01

2011-12

2011-11

2011-10

.........

2011-01

2010-12

2010-11

2010-10

.......

2010-01

2009-12

etc.

I just want to show

2012-12 as 2012

2011-12 as 2011

2010-12 as 2010

how could i do this without complicating it?

thanks a lot, and sorry for disturbing,

felipe

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Try

SubField(your_time_stamp_field,'-',1)

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

Try

SubField(your_time_stamp_field,'-',1)

felcar2013
Partner - Creator III
Partner - Creator III
Author

it worked, thanks

felipe