This is my first time using qlikview and it is pretty simple since I have experience with SQL. I am doing it for a job application but I am having one issue. I needed to do a count statement. First is it best practice to put the count in the Load Statement or in the Select statement? or does it depend on the situation? Second, I currently have it in the load statement and it is giving me an error. Here is the code:

```
//This is the Order Details Table
OrderDetails:
LOAD OrderID & LineNo as OrderLineKey, OrderID, /*LineNo,*/ Discount, ProductID, Quantity, 
 UnitPrice, UnitPrice*Quantity*(1-Discount) as Sales, Count(ProductID) as ProductIDRecordCounter;
SQL SELECT OrderID, Discount, Quantity, ProductID, UnitPrice, LineNo
FROM `Order Details`
GROUP BY OrderID, ProductID, Discount, Quantity, UnitPrice, LineNo;

```

and this is the error it is giving me:

> 
> Invalid expression SQL SELECT OrderID, Discount, Quantity, ProductID,
>  UnitPrice, LineNo FROM `Order Details` GROUP BY OrderID, ProductID,
>  Discount, Quantity, UnitPrice, LineNo
> 
> 
> 

It worked prior to adding the count statement (and of course the group by which is necessary for the statement to work)