topic Re: problem load with spaces in QlikView

problem load with spaces

Anonymous — Thu, 08 May 2014 07:38:03 GMT

During Load I need to work with leading spaces.

TEST:

Load

' no class' as ABC,

resident xyz;

In this case I see the correct value with a leading space " no class"

When I need a pre.load, the leading spaces are dropped

TEST:

Load *,

Field1;

Load

' no class' as ABC

Field2

Resident xyz,

The same happens with Inline Tables.

TEST:

Load * inline [

' no class'

' test'

'another test'

];

The field A shows all text without leading space!

Why Qlikview removes leading spaces during a pre-load or in an Inline table.

Can it be avoided? I need leading spaces!!

Qlikview 11 SR 5

Thanks for your help

Re: problem load with spaces

tresB — Thu, 08 May 2014 07:40:39 GMT

Try using text(), like:

Load

Text(A) as A ;

Load * inline [

' no class'

' test'

'another test'

];

Re: problem load with spaces

Anonymous — Thu, 08 May 2014 07:54:19 GMT

no change, the same behaviour

Re: problem load with spaces

Thu, 08 May 2014 07:57:26 GMT

Try putting

Set Verbatim = 1;

at the start of your load script

Re: problem load with spaces

its_anandrjs — Thu, 08 May 2014 07:59:23 GMT

Update new check now

Write like below script

TEST:

LOAD *,Text(A) as TextA;

Load * inline [

' no class'

' test'

'another test'

];

And plot field TextA

Re: problem load with spaces

tresB — Thu, 08 May 2014 08:00:30 GMT

set Verbatim = 1; in the script

Re: problem load with spaces

its_anandrjs — Thu, 08 May 2014 08:06:24 GMT

Did you try Text(FieldName) it works for me

TEST:

LOAD *,Text(A) as TextA;

Load * inline [

' no class'

' test'

'another test'

];

See the output

Re: problem load with spaces

Anonymous — Thu, 08 May 2014 08:16:49 GMT

it only works with "set Verbatim=1"

without that, the preleading spaces are removed

Re: problem load with spaces

Fri, 14 Jul 2017 08:32:51 GMT

Another way, instead Set Verbatim, is to use Hard Space Char(160). So, it should be like:

let vHardSpace = Chr(160)

;

Load * inline [

$(vHardSpace)My text

]

;