Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

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()))

its_anandrjs
Champion III
Champion III

Hi,

In Expression try

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


Regards

Anand


its_anandrjs
Champion III
Champion III

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
Author

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

thanks for the before Scripts and Expressions