Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
hic
Former Employee
Former Employee

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
Employee
Employee

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