topic Re: Cumulative values in QlikView

Cumulative values

ankitbisht01 — Tue, 14 Jul 2015 07:24:40 GMT

Hi, i have a sample inline table :

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

Re: Cumulative values

antoniotiman — Tue, 14 Jul 2015 07:32:54 GMT

RangeSum(Peek(Revenue),Revenue) as ProgressiveRevenue

Re: Cumulative values

qlikmsg4u — Tue, 14 Jul 2015 07:40:05 GMT

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

];

Re: Cumulative values

Chanty4u — Tue, 14 Jul 2015 07:42:46 GMT

Hi,,

PFA

hope ur requirmnt

Thank you

Suresh

Re: Cumulative values

jagan — Tue, 14 Jul 2015 07:49:04 GMT

Hi Ankit,

Try this script below

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.

Re: Cumulative values

ankitbisht01 — Tue, 14 Jul 2015 08:31:37 GMT

Thank You for instant replies