Solved: Re: Doubt in a left statement - Qlik Community

Anonymous · ‎2017-01-29

T1:

Load * Inline [

F1

123456

];

No Concatenate

T2:

Load

left([F1],2) as F2,

left([F1],-1) as Fneg // i have a doubt what this staement does.. or what is its output.

Resident T1; // what this statement does...

vinieme12 · ‎2017-01-29

try it in a text box and see for yourself

LEFT('ABCD',2) >> will return 2 character starting from left of the string, so string returned is 'AB'

LEFT('ABCD',-1) >> will return null as string starts from position 1

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2017-01-29

try it in a text box and see for yourself

LEFT('ABCD',2) >> will return 2 character starting from left of the string, so string returned is 'AB'

LEFT('ABCD',-1) >> will return null as string starts from position 1

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2017-01-29

You can find examples for all functions in Qlikview help

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2017-01-29

Thanks Vineeth.

what about Resident statement...

vinieme12 · ‎2017-01-29

You can find a lot of content just be searching the community for the related topic

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.