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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String Function


I am trying to get he first 3 letters of a char string ex: ABC0000123 . How do I do this?

I do not see the substring function though. Is there any other string function which can possibly do it?

1 Solution

Accepted Solutions
Not applicable
Author

Hi Anitha,

Try Left () Function specifying the character limit as the second parameter.

Here,

Left('ABC0000123 ',3) .

View solution in original post

2 Replies
Not applicable
Author

Hi Anitha,

Try Left () Function specifying the character limit as the second parameter.

Here,

Left('ABC0000123 ',3) .

Not applicable
Author

Thanks a lot ...