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: 
mosha231
Contributor II
Contributor II

Accumulation function on multiple selected dimensions

Hi

I have a listbox and a chart. when i select one dimension from listbox accumulation is working fine

But when i select multiple dimensions in Listbox am not getting accumulation for the results. how to make accumulation possible for multiple selected dimensions.

Thanks in advance

13 Replies
Anil_Babu_Samineni

Will you able to provide mochup application to investigate?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

What expression are you using today?

mosha231
Contributor II
Contributor II
Author

Hi

I am using expression same for both Sum(sales)/rangesum(sum(sales)) full accumulation option enabled for this , even i tried function

RangeSum(above(TOTAL sum(sales),0,RowNo(TOTAL)))

Sum(sales)/rangesum(sum(total <"MDQ SW Threshold">sales))


These functions are working fine for single selection but not for multiple selection. if i select multiple dimensions in listbox then Acc% is giving me same data as of Amount of rec column i.e no accumulation only percentage(shown in screenshot)

sunny_talwar

You are using this expression?

Sum(sales)/RangeSum(Sum(sales))? This should give you 1 for each of your dimension? RangeSum() is not even doing anything here.... I am not sure I understand your expression