Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
uridiumabs
Partner - Contributor II
Partner - Contributor II

Problem with group by clause

Hi,

I have the following code in a script:

LOAD

  ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE,

  SUM(NUM_LECTURAS)  AS IND_EFICIENCIA

RESIDENT LECTURAS

GROUP BY

  ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE

I'm not getting aggregated data as you can see below:

ID_COMMERCIAL_SITE,  ID_PROVIDER,  RECEPCION_DATE,  IND_EFICIENCIA

49255,46747,2015-04-07,7
49255,46747,2015-04-07,7
49255,46747,2015-04-08,7
49255,46747,2015-04-01,7
49255,46747,2015-04-01,7
49255,46747,2015-04-01,7
49255,46747,2015-04-30,7

What I'm doing wrong?

Thank you very much.

1 Solution

Accepted Solutions
sunny_talwar

Is your RECEPCION_DATE a date field of timestamp field? May be you need to use Floor function to make it date.

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE,

  SUM(NUM_LECTURAS)  AS IND_EFICIENCIA

GROUP BY   ID_COMMERCIAL_SITE,  ID_PROVIDER, RECEPCION_DATE;

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  Date(Floor(RECEPCION_DATE)) as RECEPCION_DATE,

  NUM_LECTURAS

RESIDENT LECTURAS

View solution in original post

3 Replies
sunny_talwar

Is your RECEPCION_DATE a date field of timestamp field? May be you need to use Floor function to make it date.

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  RECEPCION_DATE,

  SUM(NUM_LECTURAS)  AS IND_EFICIENCIA

GROUP BY   ID_COMMERCIAL_SITE,  ID_PROVIDER, RECEPCION_DATE;

LOAD ID_COMMERCIAL_SITE,

  ID_PROVIDER,

  Date(Floor(RECEPCION_DATE)) as RECEPCION_DATE,

  NUM_LECTURAS

RESIDENT LECTURAS

uridiumabs
Partner - Contributor II
Partner - Contributor II
Author

Thank you very much.

My script is working ok now.

sunny_talwar

Awesome, I am glad I was able to help