topic Accumulation in Pivot table in QlikView

Accumulation in Pivot table

boryspower — Thu, 25 Feb 2010 09:17:23 GMT

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?

Accumulation in Pivot table

Thu, 25 Feb 2010 09:32:05 GMT

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

Accumulation in Pivot table

boryspower — Thu, 25 Feb 2010 13:55:06 GMT

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

Accumulation in Pivot table

Thu, 25 Feb 2010 14:25:40 GMT

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

Accumulation in Pivot table

Thu, 25 Feb 2010 14:39:37 GMT

Accumulation in Pivot table

boryspower — Fri, 26 Feb 2010 08:54:59 GMT

That is great! Thank You for help!