Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Load script error

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!

1 Reply
MVP
MVP

Re: Load script error

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;