topic Re: Accumulation function on multiple selected dimensions in QlikView

Accumulation function on multiple selected dimensions

mosha231 — Thu, 16 Nov 2017 09:03:22 GMT

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

Re: Accumulation function on multiple selected dimensions

YoussefBelloum — Thu, 16 Nov 2017 09:07:13 GMT

Hi,

share your app or your expression

Re: Accumulation function on multiple selected dimensions

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:11:43 GMT

How is you accumulation formula looks like?

Re: Accumulation function on multiple selected dimensions

stabben23 — Thu, 16 Nov 2017 09:16:27 GMT

Hi,

I'll think you have to use a aggregation on Your "lowest" Level.

Something like this; sum(recsales)/sum(TOTAL <"MDQ SW Threshold"> recsales)

Re: Accumulation function on multiple selected dimensions

mosha231 — Thu, 16 Nov 2017 09:18:53 GMT

Hi,

Expression for both chart columns is Sum(sales)/rangesum(sum(sales)) For Ex. for HFB No. 1 sales is 10 and for all HFB sales is 100 then Amount of rec sales column will give 10% for HFB No 1. In ACC % column full accumulation option is enabled.

Re: Accumulation function on multiple selected dimensions

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:25:19 GMT

Try this?

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

Re: Accumulation function on multiple selected dimensions

stabben23 — Thu, 16 Nov 2017 09:30:00 GMT

Try this then:

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

Re: Accumulation function on multiple selected dimensions

mosha231 — Thu, 16 Nov 2017 12:02:18 GMT

Hi,

This is working for single selection but not for multiple selection in listbox.

Thanks

Re: Accumulation function on multiple selected dimensions

sunny_talwar — Thu, 16 Nov 2017 12:45:39 GMT

I guess you mentioned about what is going wrong when you select multiple dimensions, but you did not mention what you expected output needs to be? Can you share a sample app to show the issue and mention what you are looking to get?

Re: Accumulation function on multiple selected dimensions

mosha231 — Thu, 16 Nov 2017 13:49:45 GMT

thanks for your concern. like i asked in my original message is it possible to get accumulated output for multiple selections from listbox. According to screenshot 2(shown in my original message) i want Acc% output to be accumulated of Amount of rec(sales) column. like

Re: Accumulation function on multiple selected dimensions

Anil_Babu_Samineni — Thu, 16 Nov 2017 13:54:04 GMT

Will you able to provide mochup application to investigate?

Re: Accumulation function on multiple selected dimensions

sunny_talwar — Thu, 16 Nov 2017 14:01:40 GMT

What expression are you using today?

Re: Accumulation function on multiple selected dimensions

mosha231 — Thu, 16 Nov 2017 14:07:53 GMT

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)

Re: Accumulation function on multiple selected dimensions

sunny_talwar — Thu, 16 Nov 2017 14:26:11 GMT

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