Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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;