4 Replies Latest reply: Oct 25, 2011 9:33 AM by Claudia Zwick

Why is this an invalid expression?

teehiett Oct 25, 2011 8:56 AM

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?

Daniel Rozental Oct 25, 2011 9:13 AM (in response to teehiett)
Try

Group by FACILITY_NAME, Year, Month;
Like Show 0 Likes (0)

Actions
Why is this an invalid expression?

Anand Chouhan Oct 25, 2011 9:23 AM (in response to teehiett)

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
Like Show 0 Likes (0)

Actions
Why is this an invalid expression?

teehiett Oct 25, 2011 9:23 AM (in response to teehiett)

Thanks, that suggestion worked.. Now I'm wondering why?
Like Show 0 Likes (0)

Actions
- Re: Why is this an invalid expression?
  
  Claudia Zwick Oct 25, 2011 9:33 AM (in response to teehiett)
  
  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
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post