Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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
You can find examples for all functions in Qlikview help
Thanks Vineeth.
what about Resident statement...
You can find a lot of content just be searching the community for the related topic