Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakwinder
Contributor III

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
MVP
MVP

Re: Hi I'm new to Qlik Sense

Try Left(FieldName, 1) as NewField,

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

jpapador
Valued Contributor

Re: Hi I'm new to Qlik Sense

Use the function keepchar.  EX:

KeepChar(FieldName, 'a') as NewField

jpapador
Valued Contributor

Re: Hi I'm new to Qlik Sense

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

Community Browser