Cumulative values

[ankitbisht01]

Hi, i have a sample inline table :

A:

LOAD * INLINE [

    Product , Revenue

    A, 5000

    B, 10000

    C, 15000

    D, 7000

    E, 4500

    F, 5600

    G, 7000

    H, 6000

];

i wan' t to create a third column it shows cumulative values from "Revenue"

what can i use , i have little idea to use rangesum() and above function. but nt able to get output.

Thankx

[antoniotiman · Accepted solution]

RangeSum(Peek(Revenue),Revenue) as ProgressiveRevenue

[qlikmsg4u]

Hi ankit,

Please try this

Load *,RangeSum(Revenue,Peek('Cum')) as Cum;

LOAD * INLINE [

    Product , Revenue

    A, 5000

    B, 10000

    C, 15000

    D, 7000

    E, 4500

    F, 5600

    G, 7000

    H, 6000

];

[Chanty4u]

Hi,,

PFA

hope ur requirmnt

Thank you

Suresh

[jagan]

Hi Ankit,

Try this script below

A:

LOAD *,

RangeSum(Peek(CumRevenue), Revenue) AS CumRevenue

INLINE [

    Product , Revenue

    A, 5000

    B, 10000

    C, 15000

    D, 7000

    E, 4500

    F, 5600

    G, 7000

    H, 6000

];

Regards,

Jagan.

[ankitbisht01]

Thank You for instant replies