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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!