left blank lost

[#1]

Hi,everyone,

Information in the database[Datatype is Text]?
" TEST"

But,Information in Qlikview is
"TEST"

Why?how to do?

My english is very poor.

Thanks.

[Anonymous · Accepted solution]

Hello,

You should be able to use set Verbatim = 1; Please see excerpt from the F1-help below:

Verbatim

Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters.

Example:

set Verbatim = 1;

[#3]

This is my first time to ask questions.

Thank you very much.

Paul.Qian

[#4]

This is my first time to ask questions.

Thank you very much.

Paul.Qian

[Anonymous]

That's good. Just keep asking questions here if you run into any more issues. Have a nice day!