topic Re: error in expression in QlikView

error in expression

Tue, 17 Mar 2015 18:52:19 GMT

Hello,

I have a question about a expression. I have make a expression and when I click on the button reload then I get a error: invalid expression.

Can someone help me? What is wrong with the expression?

thanks in advance.

my expression is:

LOAD [%Airline ID],

[%Carrier Group ID],

[%Unique Carrier Code],

[%Unique Carrier Entity Code],

[%Region Code],

//[%Destination Airport Sequence ID],

// [%Destination Airport Market ID],

// [%Destination World Area Code],

[%Aircraft Group ID],

[%Aircraft Type ID],

[%Aircraft Configuration ID],

[%Distance Group ID],

[%Service Class ID],

[%Datasource ID],

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

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

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

Distance,

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

[Unique Carrier],

[Carrier Code],

[Carrier Name],

[Origin State Code],

Year,

Period,

Quarter,

[Month (#)],

Month

FROM

(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: error in expression

maxgro — Tue, 17 Mar 2015 22:41:20 GMT

same question?

invalid expression; what is wrong?

Re: error in expression

Wed, 18 Mar 2015 11:05:47 GMT

Hi maichel s

Your Error Show like this ????

Try it

In the ''group by", you missed fields Distance and [Origin State Code]

and mainly you check in the script function while loading the data.

Check with this

LOAD

[%Airline ID],

[%Carrier Group ID],

[%Unique Carrier Code],

[%Unique Carrier Entity Code],

[%Region Code],

//[%Destination Airport Sequence ID],

// [%Destination Airport Market ID],

// [%Destination World Area Code],

[%Aircraft Group ID],

[%Aircraft Type ID],

[%Aircraft Configuration ID],

[%Distance Group ID],

[%Service Class ID],

[%Datasource ID],

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

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

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

Distance,

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

[Unique Carrier],

[Carrier Code],

[Carrier Name],

[Origin State Code],

Year,

Period,

Quarter,

[Month (#)],

Month

FROM

(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: error in expression

mightyqlikers — Wed, 18 Mar 2015 11:25:04 GMT

I think you are missing distance field in group by caluse.

Please check.

Regards

Sawmsie

Re: error in expression

Wed, 18 Mar 2015 11:28:23 GMT

Dear,

Run step by step with dimensions.

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

Distance,

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

[Unique Carrier],

[Carrier Code],

[Carrier Name],

[Origin State Code],

Year,

Period,

Quarter,

[Month (#)],

Month

FROM

(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],Distance,

[Unique Carrier],

[Carrier Code],

[Carrier Name],

[Origin State Code],

Year,

Period,

Quarter,

[Month (#)],

Month;

Regards

Vimlesh

Re: error in expression

Gabriel — Wed, 18 Mar 2015 12:50:10 GMT

Hi,

I think you're missing Distance in GROUP BY, it's not part of aggregation so it should be in the group by.

I will add that into group by and reload.