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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register 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!