QlikView bugs. Why? How to avoid?

Sun, 24 Nov 2013 05:39:00 GMT

Mission of this topic to give a brief description of code places, where it can't be an error, but it happens.

Sometimes it can proceed without any warnings...

And you can't understand, why doesn't your application works in proper way.

I assume, it would be most effective for beginners, like I'm.

Example #1

LOAD * Inline [

'F1'

' a1'

' a2'

' a3'

];

load data without spaces in the beginning. I faced with this problem tonight.

xls-source contains spaces as hierarchy markers. And it was imbalanced tree.

I don't know, how to avoid it.

I tried with xls

LOAD

'A' & F1 as F1

FROM ...

First of all, QV decides to remove spaces and returns smth like that

Aa1

Aa2

Aa3

Please, response here if you know how to solve this problem. And I would be glad if you double your answer to my mail

Re: QlikView bugs. Why? How to avoid?

hic — Sun, 24 Nov 2013 10:25:00 GMT

It is not a bug. This is the way it is designed. Normally you want to strip all leading and trailing blanks.

However, you can turn this off by using

set Verbatim = 1;

before your load statement.

HIC

Clever_Anjos — Sun, 24 Nov 2013 20:49:18 GMT

As Henric Cronström said, set Verbatim = 1 is exactly what you need