4 Replies Latest reply: May 28, 2015 2:09 PM by Sinan Ozdemir RSS

    Equivalent of sum() over (partition by) SQL statement in QlikView

    Sinan Ozdemir

      Hi all,

       

      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.

       

      Capture.PNG

      Any help is much appreciated.

       

      Thanks