Use function Sum, Avg, and Count within a script

Fri, 06 Jan 2012 17:36:32 GMT

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

Re: Use function Sum, Avg, and Count within a script

isaiah82 — Fri, 06 Jan 2012 17:43:19 GMT

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.)

Example:

LOAD Customer, Sum(Sales), Count([No Order]) as controls
RESIDENT Invoice
GROUP BY Customer

If your source is a table file, SQL, etc. the syntax may be a little different. -Isaiah

topic Use function Sum, Avg, and Count within a script in QlikView

Use function Sum, Avg, and Count within a script

Re: Use function Sum, Avg, and Count within a script