Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

Cummulative Data

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.

1 Solution

Accepted Solutions
robin_hausdoerfer
Valued Contributor III

Re: Cummulative Data

...

17 Replies
robin_hausdoerfer
Valued Contributor III

Re: Cummulative Data

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

soniasweety
Valued Contributor III

Re: Cummulative Data

I need to separate  year also

Re: Cummulative Data

You may try like

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

-- Sent from iphone 7

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: Cummulative Data

can u attach sample qvw?

robin_hausdoerfer
Valued Contributor III

Re: Cummulative Data

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

Re: Cummulative Data

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

--  Sent  from iphone 7

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
stabben23
Honored Contributor

Re: Cummulative Data

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

soniasweety
Valued Contributor III

Re: Cummulative Data

Hi,

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

jan2014+ feb2104+mar2014 +aprl2014

stabben23
Honored Contributor

Re: Cummulative Data

like this?

2016-11-17_1909.png