Equivalent of sum() over (partition by) SQL statement in QlikView
I am quite new to QlikView and I have a fairly simple table. What I want to achieve in qlikview load script is to be able to sum Amount over Name column. Essentially, have Overall Total column populated in the load script.
Re: Equivalent of sum() over (partition by) SQL statement in QlikView
If your ODBC (or OLEDB) driver supports this SQL syntax, you can write the SELECT just as you have done. QlikView's internal syntax (Load statements) does not allow this type of syntax, so you need to do it in two steps as maxgro suggests.