Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hi I'm new to Qlik Sense

Hi,

How do i keep the first character of a field in the load script?

I only want to keep the "A" from "AJDKOPDKPDKP"

Thanks

3 Replies
sunny_talwar

Try Left(FieldName, 1) as NewField,

Update: and try not to create multiple discussion for the same requirement.

jpapador
Partner - Specialist
Partner - Specialist

Use the function keepchar.  EX:

KeepChar(FieldName, 'a') as NewField

jpapador
Partner - Specialist
Partner - Specialist

Ah never mind, read the requirement wrong.  Yes as Sunny recommends use the Left function.