topic left blank lost in QlikView

left blank lost

Tue, 05 Jan 2010 06:58:15 GMT

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.

left blank lost

Anonymous — Tue, 05 Jan 2010 07:02:45 GMT

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;

left blank lost

Tue, 05 Jan 2010 07:22:10 GMT

This is my first time to ask questions.

Thank you very much.

Paul.Qian

left blank lost

Tue, 05 Jan 2010 07:22:16 GMT

This is my first time to ask questions.

Thank you very much.

Paul.Qian

left blank lost

Anonymous — Tue, 05 Jan 2010 07:31:43 GMT

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