Accumulation in Pivot table

[boryspower]

Hi,

I have a simple example of what I want to get....

The data looks like this:

LOAD * INLINE [
Item, Data, Produced
aaa, 2010-01-01, 5
aaa, 2010-01-02, 12
aaa, 2010-01-03, 4
bbb, 2010-01-01, 57
bbb, 2010-01-03, 12
ccc, 2010-01-11, 67
ccc, 2010-01-12, 35
ccc, 2010-01-13, 7
];

So this is production of items within some days. From this I have the table:

but I'd like to have accumulated values there, so the first row would look like this:

aaa | 5 | 17 | 21 | 21 | 21 | 21 |

Is this possible?

[#2]

Hi boryspower,

This is possible ,

try by using Chart Inter Record functions

e.g. above()

For more help go through qlikview help

Topic: Chart Inter Record functions

Hope this will help you

Rahul

[boryspower]

Thank You Rahul, But do You have any idea how to apply it to my case? Where I have data placed horizontally?

[#4 · Accepted solution]

Hi,

ITEM and DATA are the dimensions

and Produced1=If(ISNULL(Sum(Produced)+ before([Produced1])),Sum(Produced),Sum(Produced)+ before([Produced1]))

as expression

Produced1 is the lable of the expression

It will work fine

Rahul

[#5]

[boryspower]

That is great! Thank You for help!