Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
v_jaideep
Creator
Creator

Accumulation in Qliksense

Hi,

I'm trying to show accumulation in a line chart . I have below expression, it works fine when only one category is selected but if I select multiple categories. It doesn't work.

RangeSum(Above(Total sum(local_price),0,RowNo(total)))  

I have 2 dimensions , Month and Category(legend).

Any suggestions on this. 

2 Replies
brunobertels
Master
Master

hi may be this 

sum(

Aggr(

RangeSum(Above(Total sum(local_price),0,RowNo(total))) ,Month,legend)

)

v_jaideep
Creator
Creator
Author

@brunobertels This does not work in my case but on a sample data this works , may be something is not wrong/missing in my original data. Thanks !!