Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dickelsa
Creator
Creator

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
Partner - Specialist
Partner - Specialist

Hi,

Try attached file.

View solution in original post

3 Replies
swuehl
MVP
MVP

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
Creator
Creator
Author

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
Partner - Specialist
Partner - Specialist

Hi,

Try attached file.