QlikView Personal creates a faulty script

Thu, 05 Dec 2013 09:25:30 GMT

Hi!

I have my data in an Excel file, created from CSV values. The script that QlikView generates is faulty. How can I correct it?

Felaktig syntax, saknad/felplacerad FROM:

LOAD [Summation column],

Id,

Requester,

[Requester id],

[Requester external id],

[Requester email],

[Requester domain],

Submitter,

Assignee,

Group,

Subject,

Tags,

Status,

Priority,

Via,

[Ticket type],

[Created at],

[Updated at],

[Assigned at],

Organization,

[Due date],

[Initially assigned at],

[Solved at],

[Resolution time],

[Satisfaction Score],

[Group stations],

[Assignee stations],

Reopens,

Replies,

[First reply time in minutes],

[First reply time in minutes within business hours],

[First resolution time in minutes],

[First resolution time in minutes within business hours],

[Full resolution time in minutes],

[Full resolution time in minutes within business hours],

[Agent wait time in minutes],

[Agent wait time in minutes within business hours],

[Requester wait time in minutes],

[Requester wait time in minutes within business hours],

[On hold time in minutes],

[On hold time in minutes within business hours],

[Type of Question

]],

[Freefloat Product

]],

[Version [txt]]],

[Device manufacturer/model [txt]]]

FROM

(ooxml, embedded labels)

LOAD [Summation column],

Id,

Requester,

[Requester id],

[Requester external id],

[Requester email],

[Requester domain],

Submitter,

Assignee,

Group,

Subject,

Tags,

Status,

Priority,

Via,

[Ticket type],

[Created at],

[Updated at],

[Assigned at],

Organization,

[Due date],

[Initially assigned at],

[Solved at],

[Resolution time],

[Satisfaction Score],

[Group stations],

[Assignee stations],

Reopens,

Replies,

[First reply time in minutes],

[First reply time in minutes within business hours],

[First resolution time in minutes],

[First resolution time in minutes within business hours],

[Full resolution time in minutes],

[Full resolution time in minutes within business hours],

[Agent wait time in minutes],

[Agent wait time in minutes within business hours],

[Requester wait time in minutes],

[Requester wait time in minutes within business hours],

[On hold time in minutes],

[On hold time in minutes within business hours],

[Type of Question

]],

[Freefloat Product

]],

[Version [txt]]],

[Device manufacturer/model [txt]]]

FROM

(ooxml, embedded labels)

Re: QlikView Personal creates a faulty script

hic — Thu, 05 Dec 2013 09:28:32 GMT

If your field names contain [ or ] , then this can happen. You need to manually change the field references to use " " instead of [ ]. Example, change

[Type of Question

]],

"Type of Question

HIC

Re: QlikView Personal creates a faulty script

Thu, 05 Dec 2013 09:39:10 GMT

That makes sense. Thanks for the tips.

But why does the wizard create a faulty script without warnings?

topic QlikView Personal creates a faulty script in QlikView

QlikView Personal creates a faulty script

Re: QlikView Personal creates a faulty script

Re: QlikView Personal creates a faulty script