1 Reply Latest reply: Sep 14, 2015 12:53 AM by Sunny Talwar RSS

    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!