Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could you please clear how trim works.
I have a values in excel like below
When i loaded the excel in Qlivkiew, i am not getting the text with leading spaces.
For example in my excel the second column apple has leading spaces. why doesnt it shoes in qlivkiew? there is no rim used inside script
Why so ?
qlik automatically trims leading and trailing spaces.
if you dont want qlik to do so you can specify using a system variable
set Verbatim = 1;
refer to below
"Normally all field values are automatically stripped of leading and trailing blanks (ASCII 32) and tabs (ASCII 9) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blanks and tabs. Hard space (ANSI 160) is never stripped."
So try putting this in your script:
set Verbatim = 1;
qlik automatically trims leading and trailing spaces.
if you dont want qlik to do so you can specify using a system variable
set Verbatim = 1;
refer to below
"Normally all field values are automatically stripped of leading and trailing blanks (ASCII 32) and tabs (ASCII 9) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blanks and tabs. Hard space (ANSI 160) is never stripped."
So try putting this in your script:
set Verbatim = 1;