Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

dickelsa
Contributor

CUMULATED COLUMN, urgent!

Hi,

I am stuck with a problem.

I want to have a table that only shows me the month, the month value, and the cumulated value up untill that month

this needs to look like this:

2015-06-25 01_07_26-Microsoft Excel (Product Activation Failed) - Book1.jpg

Can you please help me with this issue? i cannot seem to get it fixed. I think the best way is to do it in the script, but i do not know how to do this, because the way i do it, the cumulation will go on and on throughout the years

can you please help me with this?

Thanks!

Dick

1 Solution

Accepted Solutions
fvelascog72
Valued Contributor

Re: CUMULATED COLUMN, urgent!

Hi,

Try attached file.

3 Replies
MVP
MVP

Re: CUMULATED COLUMN, urgent!

How do you derive your cumulated values from the data shown? I can't see how you get to your cumulated values.

Please post a sample of your input data table and what you expect the result should look like.

dickelsa
Contributor

Re: CUMULATED COLUMN, urgent!

Hi,

See attached excel.

this is the format i get my data delivered.

The first four columns are given to me. the fifth (cumu) is the one i want to calculate.

fvelascog72
Valued Contributor

Re: CUMULATED COLUMN, urgent!

Hi,

Try attached file.