Cummulative Data

[soniasweety]

Hi all,

I have small data I need cumulative sum of data in straight table.

I have attached excel with input data and output data please look into that.

[Anonymous]

and then perhaps:

sum({<Month={"<=$(=Max(Month))"}, Year={"$(= Year(Max(Month)))"} >}Sales)

and a Dimension that combines year and month.

But your Monthfield must be a dual value.

[soniasweety]

can you share qvw?

[stabben23]

Here

[soniasweety]

will chk nd update you

[Anonymous · Accepted solution]

...

[soniasweety]

thanks robin...  will check with original data and come back to you

[MarcoWedel]

Hi,

maybe one solution could be the usage of an The As-Of Table:

tabSales:
LOAD Year,
    Month(Date#(Month,'MMM')) as Month,
    MonthName(Date#(Month&Year,'MMMYYYY')) as MonthYear,
    Region,
    City,
    Money(Sales,'#,##0 €;-#,##0 €') as Sales
FROM [https://community.qlik.com/thread/240192] (html, codepage is 1252, embedded labels, table is @1);

tabAsOfMonth:
LOAD Distinct
    MonthYear,
    MonthName(MonthYear,IterNo()-1) as AsOfMonthYear
Resident tabSales
While MonthName(MonthYear,IterNo()-1) <= Today();

hope this helps

regards

Marco

[soniasweety]

thank you. simple and nice solutions