Running Total based on second dimension

sudhakar_b — Sat, 29 Jun 2013 18:52:45 GMT

I have a straight table chart with Dimensions Date and Property and an expression with value like below:

Date	Properties	Value
11/12/2012	A/c	30
11/12/2012	Fridge	20
12/12/2012	A/c	40
12/12/2012	Fridge	30
12/12/2012	TV	60
13/12/2012	Fridge	70
13/12/2012	LCD	40

I need the another expression added to this chart like the following

Date	Properties	Value	Total
11/12/2012	A/c	30	30
11/12/2012	Fridge	20	20
12/12/2012	A/c	40	70
12/12/2012	Fridge	30	50
12/12/2012	TV	60	60
13/12/2012	Fridge	70	120
13/12/2012	LCD	40	40

Basically a running total on the second dimension value(A/c values get added, Fridge values get added etc.). The sort order has to be date first and then property.

We are able to accomplish this if the sort is on property first with the above function. Also we could have two year data on the table with hundreds of properties. So need a flexible solution. Everything needs to happen in the chart not at the script level.

Any pointers is appreciated.

topic Running Total based on second dimension in QlikView

Running Total based on second dimension