Load script error

[#1]

Hey guys, could use a little guidance on preparing load files, happy to read through some resources as well.

Just began using Qlik sense and i'm trying to do a simple transformation of data columns upon loading a data file.

Input:

Revenue

Country

Orders

Output:

Average order value of each country

Current attempt:

Load ((Sum([Revenue with shipping]),[Country Code])/(sum([unique orders]))) as AOV

Thanks!

[sunny_talwar]

Try something like this:

Input:

LOAD Revenue,

Country,

Orders

FROM Source;

Join(Input)

LOAD Country,

          Avg(Orders) as [Avg Orders]

Resident Input

Group By Country;