Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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