topic Re: Cumulative sum in QlikView

Cumulative sum

Anonymous — Wed, 06 Jul 2016 08:59:33 GMT

Hi guys,

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

richard_chilvers — Wed, 06 Jul 2016 09:15:15 GMT

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

FROM ....................

GROUP BY Name;

Of course, in your example, this would give Bob a total of 20.

Do you need something different ?

Gysbert_Wassenaar — Wed, 06 Jul 2016 09:16:24 GMT

LOAD

Name,

Sum([Purchase amount]) as [Purchase amount]

GROUP BY

Name;

LOAD DISTINCT * INLINE [

];

qlikview979 — Wed, 06 Jul 2016 09:24:27 GMT

Hi Paul,

In your table "Bob" having sum 20 like (10+5+5). how you calculated 15?

Regards