topic invalid expression? in QlikView

invalid expression?

Mon, 14 Nov 2011 11:02:56 GMT

Hi,

Can anyone help with my script (I am a newbie on QlikView) below.

I am getting an error in the expression sum([Project Revenue] / sum([Hours Quantity]. Why?

thanks!

//*****Work*****

Work:

LOAD

[Project Number],

[Project Name],

[Project Type],

[Customer Name],

[Full Name] as Employee,

[Prod Unit Code],

Skill,

[Hours Quantity],

[Task Name],

[Task Number],

[Expenditure Type],

[Bill Rate],

[Cost Rate],

[Project Revenue],

[Project Cost],

Month,

[Project Revenue]-[Project Cost] as Contribution

FROM

[..\reformatted\Weekly CSD September_Aug_dummydata.xlsx]

(ooxml, embedded labels, header is 3 lines, table is [Rapport 1]);

Join (Work)

LOAD [Project Number],

sum([Project Revenue])/sum([Project Revenue]) as COR

Resident Work;

invalid expression?

m_woolf — Mon, 14 Nov 2011 11:06:44 GMT

No comma at end?

invalid expression?

llauses243 — Mon, 14 Nov 2011 11:11:20 GMT

Hi,

In general when you use sum or count or ...

Also you must to use group by

I suggest you review help LOAD

Good luck, Luis

invalid expression?

Mon, 14 Nov 2011 11:14:30 GMT

Hi Gordaman,

The first thing I see is sum([Project Revenue])/sum([Project Revenue]) as COR this is twice the same variable.

If you want sum([Project Revenue]) you should use an aggregation variable.

Below resident you type group by.

Hope this is helpful.

gr.

Frank

invalid expression?

SunilChauhan — Mon, 14 Nov 2011 11:16:56 GMT

use group by in resident table like below

//*****Work*****

Work:

LOAD

[Project Number],

[Project Name],

[Project Type],

[Customer Name],

[Full Name] as Employee,

[Prod Unit Code],

Skill,

[Hours Quantity],

[Task Name],

[Task Number],

[Expenditure Type],

[Bill Rate],

[Cost Rate],

[Project Revenue],

[Project Cost],

Month,

[Project Revenue]-[Project Cost] as Contribution

FROM

[..\reformatted\Weekly CSD September_Aug_dummydata.xlsx]

(ooxml, embedded labels, header is 3 lines, table is [Rapport 1]);

Join (Work)

LOAD [Project Number],

sum([Project Revenue])/sum([Project Revenue]) as COR

Resident Work group BY [Project Number],;

invalid expression?

Mon, 14 Nov 2011 11:33:21 GMT

Thanks everyone! I got it working now!