topic Manual Accumulation with two dimensions in QlikView

Manual Accumulation with two dimensions

maxsheva — Mon, 10 Apr 2017 18:36:39 GMT

Hi,

How can I create the same Full Accumulation for two dimensions as QV do it?

I use formula RangeSum(Above(TOTAL Aggr(Sum(Value1),Date),0, Date))

But in this case Accumulation is for all fields in Example field.

I need the same view like in "Accum Auto" expression.

The data and qvw file are below.

Thx.

Table1:

LOAD * INLINE [

Example, Date, Value1, Value2

Example1, 01/02/2017, 70, 70

Example1, 01/04/2017, 80, 80

Example1, 01/07/2017, 50, 30

Example1, 01/09/2017, 30, 50

Example2, 01/12/2017, 70, 70

Example2, 01/15/2017, 80, 80

];

tmp:

LOAD

Example,

Date(min(Date)) as MinDate,

Date(max(Date)) as MaxDate

Resident Table1

Group By Example;

LOAD

Example,

Date(MinDate + IterNo() -1) as Date

Resident tmp

While Date(MinDate + IterNo() -1) <= MaxDate;

DROP Table tmp;

sunny_talwar — Mon, 10 Apr 2017 18:53:12 GMT

If you have QV12, you can try this

Aggr(RangeSum(Above(Sum(Value1),0, RowNo())), Example, (Date,(NUMERIC)))

or if its okay, sort 1st by Example and then by Date ascending in your chart with this expression

RangeSum(Above(Sum(Value1),0, RowNo()))

maxsheva — Mon, 10 Apr 2017 19:13:29 GMT

Thank you Sunny, it works!

Is it normal for QV to use value which is not exist in data model such as 'NUMERIC'?

sunny_talwar — Mon, 10 Apr 2017 19:14:19 GMT

Yes, this is a new feature introduced with QV12. Take a look here