Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Nirpanthan
Contributor III
Contributor III

QLIKSENSE ACCUMULATION IN STRAIGHT TABLE

rangesum(above(Sum({<Periodname,Segment3={440},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={470},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={480},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={490},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={510},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance),0,rowno())) 

 

Can any one help 

Labels (1)
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

And your question is?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Nirpanthan
Contributor III
Contributor III
Author

Yes i want a+b in c  

For eg 

month,Amount

jan,100

feb,200

march,400

 

if clicked in march  i want value as 400+200+100=700 in march