Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Accumulative

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

Report.png

4 Replies
MVP
MVP

Re: Accumulative

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

NO

Date

ID

Expression

Value

SUM(Value)

O/P

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

Re: Accumulative

Hi,

In Expression try

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


Regards

Anand


Highlighted

Re: Accumulative

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

Accumulation.png

Regards

Anand

Not applicable

Re: Accumulative

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

thanks for the before Scripts and Expressions