Discussion board where members can get started with Qlik Sense.
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.
Average order value of each country
Load ((Sum([Revenue with shipping]),[Country Code])/(sum([unique orders]))) as AOV
Try something like this:
Avg(Orders) as [Avg Orders]
Group By Country;