Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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
Alex
Tomas
Bentwood
Detroit
here Tomas and Detroit should be loaded with space as a first character
Thankyou
Hi,
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
regards
Marco
If you want to load space as a first characters use the below script
Load
' '&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.
- Marcus
Hi,
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
regards
Marco
Set Verbatim = 0;
should turn the autotrim on again.
regards
Marco
it's not working with me Y?
By default in my Qlikview it's taking Default values see attachments