Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart Accumlulation of sales-ASAP

hi,

i ahve requirement like

sales of years  start from 2000 in 200 sum sales=sum of sales of in the yr 2000 and next year

i.e 2001 it should diplay sum of sales in 2000 and 2001lik that in 2002 the sum of the the sales of three years lik 2000 ,2001 and 2002

lik so if it is 2010 then sum of sales of all prevoius yrs.

1 Solution

Accepted Solutions
Specialist II
Specialist II

on expression tab use the accumulation option, you can find it left down.

you can define it ,how back step you want to accumulate, and full accumulation as well.

try this option and let us know.

View solution in original post

6 Replies
Not applicable

year     sales  SUM  (sales)

------     --------  ---------------

2000     100     100

2001      150     250

2002      350      700

2003       100      800

lik that

Specialist II
Specialist II

on expression tab use the accumulation option, you can find it left down.

you can define it ,how back step you want to accumulate, and full accumulation as well.

try this option and let us know.

View solution in original post

Not applicable

Try this..

Goto properties-->Expression--> Accumulation-- > Full Accumulation..

Kabilan K.

Not applicable

Thank u i got it.Thanks for timely help

regrds

Mahesh

Specialist II
Specialist II

if u got it then close the thread..

Not applicable

Hi,

Use Rangesum function.

Regards,

Piyush