Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
can you share qvw?
Here
will chk nd update you
...
thanks robin... will check with original data and come back to you
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
thank you. simple and nice solutions