topic Re: Accumulative in QlikView

Accumulative

Tue, 04 Nov 2014 13:15:17 GMT

Hi This is my Report I need to O/P Like This Pls anyone Send the Expression For this Report.

I need it urgently.

Thanks in advance

Re: Accumulative

MK_QSL — Tue, 04 Nov 2014 13:26:24 GMT

Script

===================================

Temp:
Load Date, ID, Value From TableName;

Final:

Load *, RowNo() as NO Resident Temp Order By Date, ID;

Drop Table Temp;

=========================================

Create Straight Table

Dimension

Date

Expression

Value

SUM(Value)

O/P

RangeSum(Above(SUM(Value),0,RowNo()))

Re: Accumulative

its_anandrjs — Tue, 04 Nov 2014 13:28:42 GMT

Hi,

In Expression try

rangesum(above(sum(Value, 0 , RowNo())))

Regards

Anand

Re: Accumulative

its_anandrjs — Tue, 04 Nov 2014 13:56:56 GMT

Hi,

In load script you can use it like

Tab1:

LOAD * INLINE [

Date, ID, Value, O/P

10-10-2009, A, 10, 10

10-10-2009, A, 15, 25

10-10-2009, A, 5, 30

10-10-2009, A, 40, 70

10-10-2009, A, 20, 90

10-10-2009, B, 10, 10

10-10-2009, B, 20, 30

10-10-2009, B, 15, 45

10-10-2009, B, 45, 90

10-10-2009, B, 25, 115

10-10-2009, B, 10, 125

10-10-2009, C, 5, 5

10-10-2009, C, 15, 20

10-10-2009, C, 20, 40

10-10-2009, C, 10, 50

10-10-2009, C, 25, 75

10-10-2009 C, 12, 87

10-10-2009, C, 10, 97

10-10-2009, C, 20, 117

10-10-2009, C, 50, 167

];

New:

LOAD

Date,ID,Value,

if(Previous(ID) = ID, Value + Peek(OP),Value) as OP

Resident Tab1;

DROP Table Tab1;

And you get this records

Regards

Anand

Re: Accumulative

Fri, 07 Nov 2014 13:56:37 GMT

Actually i have tried these things and it worked,,bt i need it in some other way...

thanks for the before Scripts and Expressions