Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract from a dimension

Hi, how can i extract from a listing of elements the 2 first letters of each element in the dimensión?

As an example:

FI0540

MO3124

RT1147

I want a list of

FI

MO

RT

Thanks!

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

=left(fieldname,2)

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

=left(fieldname,2)

-Rob

Not applicable
Author

Thanks Rob!