Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Why is this an invalid expression?


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;

Tags (2)
1 Solution

Accepted Solutions
danielrozental
Not applicable

Why is this an invalid expression?

Try

Group by  FACILITY_NAME, Year, Month;
4 Replies
danielrozental
Not applicable

Why is this an invalid expression?

Try

Group by  FACILITY_NAME, Year, Month;
its_anandrjs
Not applicable

Why is this an invalid expression?

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

Not applicable

Why is this an invalid expression?

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

Not applicable

Re: Why is this an invalid expression?

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