Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load space before Names from Excel

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

1 Solution

Accepted Solutions

Re: Load space before Names from Excel

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

7 Replies
jebamalai
Valued Contributor

Re: Load space before Names from Excel

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

Load

' '&Name as Name

Not applicable

Re: Load space before Names from Excel

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

aveeeeeee7en
Valued Contributor III

Re: Load space before Names from Excel

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

Try it with text(Names) as Names.

- Marcus

Re: Load space before Names from Excel

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

Set Verbatim = 0;


should turn the autotrim on again.


regards


Marco

qlikpahadi07
Valued Contributor

Re: Re: Load space before Names from Excel

it's not working with me Y?

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

Community Browser