Discussion Board for collaboration on QlikView Scripting.
I have the following
Is there any way in my load script i can have a cumulative sum on purchase amount so the table ends up looking like this
Go to Solution.
I suggest you use the GROUP BY feature in the load (check it out in the documentation.
It will be along the lines of:
LOAD Name, SUM([Purchase Amount]) as Total_Purchase
GROUP BY Name;
Of course, in your example, this would give Bob a total of 20.
Do you need something different ?
Sum([Purchase amount]) as [Purchase amount]
LOAD DISTINCT * INLINE [
In your table "Bob" having sum 20 like (10+5+5). how you calculated 15?