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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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 ...