topic Re: cumm Sum in QlikView

cumm Sum

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have the data on date level.

I want to calculate cumulative sum of the Sales for category A.

My formula is sum({<Flag={'A'}>}Sales) .

How to write the cumulative sum for the selected month for each year.

Thanks in advance.

Re: cumm Sum

sunny_talwar — Thu, 08 Sep 2016 02:57:08 GMT

What is the number you are expecting to see here?

Re: cumm Sum

sunny_talwar — Thu, 08 Sep 2016 03:03:54 GMT

May be this:

='Cummulative Category A Sales ' & Num(Sum({<Flag={'A'}, MonthYear = {"$(='>=' & Date(YearStart(Max(MonthYear)), 'MMM-YY') & '<=' & Date(Max(MonthYear), 'MMM-YY'))"}, Month>}Sales),'#,##0.00')

Re: cumm Sum

ziadm — Thu, 08 Sep 2016 03:14:14 GMT

Create another AsofTable and make MonthYear as the key to link your sales table with the AsofTable

AsofMonth:

load

MonthYear ,

Sum(Sales) as MonthSale

Resident Dept_Sales

Group by MonthYear;

The formula will be

sum({<Flag={'A'}>} MonthSale )