Discussion Board for collaboration related to QlikView App Development.
Is it possible to use the functions sum, avg and count in a script (LOAD Customer, Sum (Sales) as Sales, Count (No Order) as controls NB Resident invoice;)? every time I use one of these functions have an error Espression thank you
Sure, you can use these in a script but you would have to use a GROUP BY clause in your LOAD statement (similar to, but different than sending a GROUP BY clause in an SQL statement.)
LOAD Customer, Sum(Sales), Count([No Order]) as controlsRESIDENT InvoiceGROUP BY Customer
If your source is a table file, SQL, etc. the syntax may be a little different. -Isaiah