Discussion Board for collaboration on QlikView Scripting.
I am loading 4 Names from excel, but 2 names are having space as a first character. When I load into Qlikview Listbox shows Names without space. But how should I load with space for those names.
ex: Name --------FieldName
here Tomas and Detroit should be loaded with space as a first character
Go to Solution.
it is QlikView default behaviour to trim loaded field values.
To turn this behaviour off, just add the line
Set Verbatim = 1;
to your script prior to loading those names.
hope this helps
If you want to load space as a first characters use the below script
' '&Name as Name
If I do that for all the Names I ll get space, But I want only to 2 names. Thanks
If possible please attach your Application(qvw).
Are You using some Where condition ( Len(Trim()) ) in your Table.
Try it with text(Names) as Names.
Set Verbatim = 0;
should turn the autotrim on again.
it's not working with me Y?
By default in my Qlikview it's taking Default values see attachments