topic Re: Cummulative Data in QlikView

Cummulative Data

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Cummulative Data

Anonymous — Thu, 17 Nov 2016 17:54:44 GMT

do you like to separate it by year or not?!?

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 17:56:37 GMT

I need to separate year also

Re: Cummulative Data

Anil_Babu_Samineni — Thu, 17 Nov 2016 17:58:19 GMT

You may try like

Sum({<month = {">=getfieldselections(month) <=month(monthstart(max(year)))}>}sales)

-- Sent from iphone 7

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 18:01:23 GMT

can u attach sample qvw?

Re: Cummulative Data

Anonymous — Thu, 17 Nov 2016 18:01:34 GMT

if you select april 2015, what do you expect as output?

Re: Cummulative Data

Anil_Babu_Samineni — Thu, 17 Nov 2016 18:05:03 GMT

I don't have system at this time, I may sent once I got chance to machine.

-- Sent from iphone 7

Re: Cummulative Data

stabben23 — Thu, 17 Nov 2016 18:06:46 GMT

Try this first, this will gives you all the month you want: sum({<Month={"<=$(=Max(Month))"}>}Sales)

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 18:09:03 GMT

Hi,

If I select aprl2014 in list boxes.... I need to get output as

jan2014+ feb2104+mar2014 +aprl2014

Re: Cummulative Data

stabben23 — Thu, 17 Nov 2016 18:11:00 GMT

like this?

Re: Cummulative Data

Anonymous — Thu, 17 Nov 2016 18:13:07 GMT

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.

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 18:15:17 GMT

can you share qvw?

Re: Cummulative Data

stabben23 — Thu, 17 Nov 2016 18:20:03 GMT

Here

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 18:26:05 GMT

will chk nd update you

Re: Cummulative Data

Anonymous — Thu, 17 Nov 2016 18:53:59 GMT

...

Re: Cummulative Data

soniasweety — Thu, 17 Nov 2016 19:02:53 GMT

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

Re: Cummulative Data

MarcoWedel — Thu, 17 Nov 2016 22:20:19 GMT

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

Re: Cummulative Data

soniasweety — Fri, 18 Nov 2016 04:47:59 GMT

thank you. simple and nice solutions