Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

QlikView bugs. Why? How to avoid?

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

nikolay.dolgonosv@atkcg.ru

2 Replies

Re: QlikView bugs. Why? How to avoid?

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

Employee
Employee

Re: QlikView bugs. Why? How to avoid?

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