Group by order by

[QlikTonic]

Hi evrybody,

i need your help please.

when i write this code :

Load
AppelDate as DateC,
CompteurAppel as AppelC,
ParkingSortie as ParkC
Resident Conversation
where not isnull (ParkingSortie)
Order by AppelDate;

i would like to have a total by DateC then i write :

Load
AppelDate as DateC,
sum(CompteurAppel) as NombreAppel,
ParkingSortie as ParkC
Resident Conversation
where not isnull (ParkingSortie)
Order by AppelDate

Group by AppelDate;

But it dosn t work, i don't understand what is wrong, can someone help me please ?

i tried also :

TableAppels:

load *,
sum(AppelC) as NombreAppel
Group by DateC;

Load
AppelDate as DateC,
CompteurAppel as AppelC,
ParkingSortie as ParkC
Resident Conversation
where not isnull (ParkingSortie)
Order by AppelDate;

Probably not difficult but...

Thanks in advanced

C.

[dplr-rn · Accepted solution]

You need to group by all the columns that you are not aggregating. 

E.g. ParkingSortie

If you don't want to do that. Remove parkingsortie and load with group by and join it to main table

Load
AppelDate as DateC,
sum(CompteurAppel) as NombreAppel
Resident Conversation
where not isnull (ParkingSortie)
Order by AppelDate

[QlikTonic]

Thanks a lot !

Have a nice day