Load space before Names from Excel

[#1]

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

[Anonymous]

If you want to load space as a first characters use the below script

Load

' '&Name as Name

[#3]

If I do that for all the Names I ll get space, But I want only to 2 names. Thanks

[aveeeeeee7en]

If possible please attach your Application(qvw).

Are You using some Where condition ( Len(Trim()) ) in your Table.

[marcus_sommer]

Try it with text(Names) as Names.

- Marcus

[MarcoWedel · Accepted solution]

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

[MarcoWedel]

Set Verbatim = 0;

should turn the autotrim on again.

regards

Marco

[qlikpahadi07]

it's not working with me Y?

By default in my Qlikview it's taking Default values see attachments