This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
During Load I need to work with leading spaces.
' no class' as ABC,
In this case I see the correct value with a leading space " no class"
When I need a pre.load, the leading spaces are dropped
' no class' as ABC
The same happens with Inline Tables.
Load * inline [
' no class'
The field A shows all text without leading space!
Why Qlikview removes leading spaces during a pre-load or in an Inline table.
Can it be avoided? I need leading spaces!!
Qlikview 11 SR 5
Thanks for your help
Set Verbatim = 1;
at the start of your load script
View solution in original post
Try using text(), like:
Text(A) as A ;
no change, the same behaviour
Update new check now
Write like below script
LOAD *,Text(A) as TextA;
And plot field TextA
set Verbatim = 1; in the script
Did you try Text(FieldName) it works for me
See the output
it only works with "set Verbatim=1"
without that, the preleading spaces are removed
Another way, instead Set Verbatim, is to use Hard Space Char(160). So, it should be like:
let vHardSpace = Chr(160)