Accumulation - again

Sun, 16 Dec 2012 09:10:42 GMT

Hello

I have a table :

Invent:

LOAD

Date,

custaccount,

dataareaid,

Enterp,

inventbatchid,

inventlocationid,

inventtransid,

itemid,

itemgroupid,

qty,

transtype,

transtypeName,

vendaccount

Resident InventTEMP2

Where itemgroupid = 'MM' and Match(dataareaid,'a','b','c','d','e','f','g','h')>0 and Date<=Today();

At the moment there is data for the last five years. qty is number (quantity), other fields are dimensions

qty shows movement, but what I need is balance. For each date, for each dimension. So - at the moment to get balance in chart I have to sum every movement for last 5 years. This is really slow and date dimensions are not fully useable.

The only solution what I can image is to calculate balance in script. But how to do this - I dont have skills for that

The important thing is, that there is possibility that within one date can every dimension and their combination be used more than once.

Thanks in advance

Re: Accumulation - again

Anonymous — Sun, 16 Dec 2012 09:30:35 GMT

There is an excellent example that is well commented and easy to follow at: http://community.qlik.com/message/16104#16104

Jonathan

topic Re: Accumulation - again in QlikView

Accumulation - again

Re: Accumulation - again