topic Re: Load space before Names from Excel in QlikView

Load space before Names from Excel

Sat, 02 Aug 2014 16:28:48 GMT

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

Re: Load space before Names from Excel

Anonymous — Sat, 02 Aug 2014 17:28:18 GMT

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

Load

' '&Name as Name

Re: Load space before Names from Excel

Sat, 02 Aug 2014 17:58:36 GMT

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

Re: Load space before Names from Excel

aveeeeeee7en — Sat, 02 Aug 2014 18:01:32 GMT

If possible please attach your Application(qvw).

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

Re: Load space before Names from Excel

marcus_sommer — Sat, 02 Aug 2014 18:33:03 GMT

Try it with text(Names) as Names.

- Marcus

Re: Load space before Names from Excel

MarcoWedel — Sat, 02 Aug 2014 22:02:08 GMT

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

Re: Load space before Names from Excel

MarcoWedel — Sat, 02 Aug 2014 22:07:26 GMT

Set Verbatim = 0;

should turn the autotrim on again.

regards

Marco

Re: Re: Load space before Names from Excel

qlikpahadi07 — Sun, 03 Aug 2014 08:05:13 GMT

it's not working with me Y?

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