Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

scripting

what is wrong with below script?

Load

country,

sum(sales)

from sales.qvd;

Tags (1)
3 Replies
MVP
MVP

Re: scripting

Missing group by. Try like:

Load

country,

sum(sales)

from sales.qvd group by country;

Re: scripting

Group By is missing

Load

country,

sum(sales)

from sales.qvd

Group By

country;

Regards

Anand

Re: scripting

When using aggregation functions (count, sum, min, max, avg, ...) in a load (or select), you have to include ALL fields without aggregation function in the group by clause.

hope this helps

regards

Marco

Community Browser