topic Why is this an invalid expression? in QlikView

Why is this an invalid expression?

Tue, 25 Oct 2011 12:56:15 GMT

Hi, I'm just getting into QlikView and trying to learn..... I cannot see the error in the following expression, even thought I know it must be simple. Suggestions? Thanks, Tee


LOAD count(SURGEON) as cases, 
     FACILITY_NAME, 
     Year, 
     Month
From
D:\Documents\QlikView\t_SampleData.xlsx
(ooxml, embedded labels)
where FACILITY_NAME like '*South' and Year = '2011' 
Group by  SURGEON,Month;

Why is this an invalid expression?

danielrozental — Tue, 25 Oct 2011 13:13:17 GMT

Try

Group by  FACILITY_NAME, Year, Month;

Why is this an invalid expression?

its_anandrjs — Tue, 25 Oct 2011 13:23:33 GMT

Hi,

You have to write

LOAD count(SURGEON) as cases,

FACILITY_NAME,

Year,

Month

From

t_SampleData.xlsx

(ooxml, embedded labels, table is Sheet1)

where FACILITY_NAME = 'South' and Year = 2011

Group by FACILITY_NAME, Year, Month;

Rgds

Anand

Why is this an invalid expression?

Tue, 25 Oct 2011 13:23:35 GMT

Thanks, that suggestion worked.. Now I'm wondering why?

Re: Why is this an invalid expression?

Tue, 25 Oct 2011 13:31:13 GMT

hi,

You cannot group by over a field you use in an expression. That's normal, because you want to count or sum this field. You always have to group by over all the other fields.

More details you find in the manuel help under the capitel "script".

Regards

vicky