Invalid expression error - Qlikview 11 for developers

[#1]

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;

[maxgro]

could you post the qvd?

EDIT: I found it, don't post

[maxgro]

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;

[arsal_90]

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];

[#5 · Accepted solution]

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.