Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Extract from a dimension

=left(fieldname,2)

-Rob

2 Replies

Re: Extract from a dimension

=left(fieldname,2)

-Rob

Not applicable

Re: Extract from a dimension

Thanks Rob!

Community Browser