topic Re: Invalid expression error - Qlikview 11 for developers in QlikView

Invalid expression error - Qlikview 11 for developers

Sat, 12 Apr 2014 06:19:56 GMT

The whole script from page 415 is given below. When I remove the part after "group by", and run, I get a script error - Invalid Expression (Since no grouping of non-aggregated fields ???). When I include "group by", it says "Unknown statement - Group By" (illegal syntax ??? but the book uses it.). What is my mistake here ?

Flights:

LOAD

[%Airline ID],

[%Carrier Group ID],

[%Unique Carrier Code],

[%Unique Carrier Entity Code],

[%Region Code],

[%Aircraft Group ID],

[%Aircraft Type ID],

[%Aircraft Configuration ID],

[%Distance Group ID],

[%Service Class ID],

[%Datasource ID],

[Unique Carrier],

[Carrier Code],

[Carrier Name],

Year,

Period,

Quarter,

[Month (#)],

Month,

Sum([# Departures Scheduled]) as [# Departures Scheduled],

Sum([# Departures Performed]) as [# Departures Performed],

Sum([# Payload]) as [# Payload],

Sum([# Available Seats]) as [# Available Seats],

Sum([# Transported Passengers]) as [# Transported

Passengers],

Sum([# Transported Freight]) as [# Transported Freight],

Sum([# Transported Mail]) as [# Transported Mail],

Sum([# Ramp-To-Ramp Time]) as [# Ramp-To-Ramp Time],

Sum([# Air Time]) as [# Air Time]

FROM

[..\3.QVD\Source\Flight Data.qvd]

(qvd)

Group By

[%Airline ID], [%Carrier Group ID], [%Unique Carrier Code],

[%Unique Carrier Entity Code], [%Region Code], [%Aircraft Group

ID],

[%Aircraft Type ID], [%Aircraft Configuration ID], [%Distance

Group ID],

[%Service Class ID], [%Datasource ID], [Unique Carrier], [Carrier

Code],

[Carrier Name], Year, Period, Quarter, [Month (#)], Month;

Re: Invalid expression error - Qlikview 11 for developers

maxgro — Sat, 12 Apr 2014 06:28:32 GMT

could you post the qvd?

EDIT: I found it, don't post

Re: Invalid expression error - Qlikview 11 for developers

maxgro — Sat, 12 Apr 2014 06:39:36 GMT

this (I copy your script) works with qvd find here

I bought the book and need flightdata.qvd file to practice...any help is highly appreciated...

perhaps somes field you split in different lines?

Flights:

LOAD

[%Airline ID],

[%Carrier Group ID],

[%Unique Carrier Code],

[%Unique Carrier Entity Code],

[%Region Code],

[%Aircraft Group ID],

[%Aircraft Type ID],

[%Aircraft Configuration ID],

[%Distance Group ID],

[%Service Class ID],

[%Datasource ID],

[Unique Carrier],

[Carrier Code],

[Carrier Name],

Year,

Period,

Quarter,

[Month (#)],

Month,

Sum([# Departures Scheduled]) as [# Departures Scheduled],

Sum([# Departures Performed]) as [# Departures Performed],

Sum([# Payload]) as [# Payload],

Sum([# Available Seats]) as [# Available Seats],

Sum([# Transported Passengers]) as [# Transported

Passengers],

Sum([# Transported Freight]) as [# Transported Freight],

Sum([# Transported Mail]) as [# Transported Mail],

Sum([# Ramp-To-Ramp Time]) as [# Ramp-To-Ramp Time],

Sum([# Air Time]) as [# Air Time]

FROM

[..\3.QVD\Source\Flight Data.qvd]

(qvd)

//FROM

//[Flight Data.qvd]

//(qvd)

Group By

[%Airline ID], [%Carrier Group ID], [%Unique Carrier Code],

[%Unique Carrier Entity Code], [%Region Code], [%Aircraft Group ID],

[%Aircraft Type ID], [%Aircraft Configuration ID], [%Distance Group ID],

[%Service Class ID], [%Datasource ID], [Unique Carrier], [Carrier Code],

[Carrier Name], Year, Period, Quarter, [Month (#)], Month;

Re: Invalid expression error - Qlikview 11 for developers

arsal_90 — Sat, 12 Apr 2014 06:47:50 GMT

LOAD [%Airline ID],

[%Carrier Group ID],

[%Unique Carrier Code],

[%Unique Carrier Entity Code],

[%Region Code],

[%Aircraft Group ID],

[%Aircraft Type ID],

[%Aircraft Configuration ID],

[%Distance Group ID],

[%Service Class ID],

[%Datasource ID],

[Unique Carrier],

[Carrier Code],

[Carrier Name],

Year,

Period,

Quarter,

[Month (#)],

Month,

Sum([# Departures Scheduled]) as [# Departures Scheduled],

Sum([# Departures Performed]) as [# Departures Performed],

Sum([# Payload]) as [# Payload],

Sum([# Available Seats]) as [# Available Seats],

Sum([# Transported Passengers]) as [# Transported Passengers],

Sum([# Transported Freight]) as [# Transported Freight],

Sum([# Transported Mail]) as [# Transported Mail],

Sum([# Ramp-To-Ramp Time]) as [# Ramp-To-Ramp Time],

Sum([# Air Time]) as [# Air Time]

FROM

[..\3.QVD\Source\Flight Data.qvd]

(qvd)

Group By

[%Unique Carrier Code], [%Airline ID], [Unique Carrier], [%Unique Carrier Entity Code],

[%Region Code], [Carrier Code], [Carrier Name], [%Carrier Group ID],

[%Aircraft Group ID], [%Aircraft Type ID], [%Aircraft Configuration ID],

Period, Year, Quarter, [Month (#)], Month, [%Distance Group ID], [%Service Class ID], [%Datasource ID];

Store [Flight Data] into ;

Drop Table [Flight Data];

Re: Invalid expression error - Qlikview 11 for developers

Sat, 12 Apr 2014 22:57:37 GMT

damn... i now noticed that little semi-colon at the end of the load statement "

FROM

[..\3.QVD\Source\Flight Data.qvd]

(qvd) ;

". It should be removed.

After that, I got a new error - Field "%Aircraft Group ID" not found.

That is because the field name did not have proper spacing -

[%Aircraft Group

ID]

Put a space between Group and ID. Do this for all fields which are split into

multiple lines to be sure.