Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Employee
Employee

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

Community Browser