topic Accumulation Function with multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/Accumulation-Function-with-multiple-dimensions/m-p/1428442#M429951 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to do accumulation in Acc% column based on values in No of SKU within threshold % column.&nbsp; For this i have enabled the full accumulation option. This function is working fine when i select one dimension from RANGE listbox. but when i select multiple dimensions accumulation spilts up&nbsp; </P><P></P><P></P><P>Acc% when one dimension selected</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183960_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Acc % when multiple dimension&nbsp; selected</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/183963_pastedImage_5.png" style="max-width: 1200px; max-height: 900px;" /></P><P>i see for same number of PRA_NO accumulation is fine then again it changes when PRA_NO changes(shown in Green rectangles)</P><P>Is there is some link between green marked rectangles? if yes how to resolve this. i want my ACC% column to give accumulated data based on No of SKU within threshold % column on whatever dimension(even multiple selection) i select.</P><P></P><P>One more thing i have enabled relative function in expression. is that have something to do with it</P><P></P><P>BIG THANKS IN ADVANCE!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Nov 2017 22:01:17 GMT mosha231 2017-11-20T22:01:17Z Accumulation Function with multiple dimensions https://community.qlik.com/t5/QlikView/Accumulation-Function-with-multiple-dimensions/m-p/1428442#M429951 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to do accumulation in Acc% column based on values in No of SKU within threshold % column.&nbsp; For this i have enabled the full accumulation option. This function is working fine when i select one dimension from RANGE listbox. but when i select multiple dimensions accumulation spilts up&nbsp; </P><P></P><P></P><P>Acc% when one dimension selected</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183960_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Acc % when multiple dimension&nbsp; selected</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/183963_pastedImage_5.png" style="max-width: 1200px; max-height: 900px;" /></P><P>i see for same number of PRA_NO accumulation is fine then again it changes when PRA_NO changes(shown in Green rectangles)</P><P>Is there is some link between green marked rectangles? if yes how to resolve this. i want my ACC% column to give accumulated data based on No of SKU within threshold % column on whatever dimension(even multiple selection) i select.</P><P></P><P>One more thing i have enabled relative function in expression. is that have something to do with it</P><P></P><P>BIG THANKS IN ADVANCE!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Nov 2017 22:01:17 GMT https://community.qlik.com/t5/QlikView/Accumulation-Function-with-multiple-dimensions/m-p/1428442#M429951 mosha231 2017-11-20T22:01:17Z Re: Accumulation Function with multiple dimensions https://community.qlik.com/t5/QlikView/Accumulation-Function-with-multiple-dimensions/m-p/1428443#M429952 <HTML><HEAD></HEAD><BODY><P>Can you attach sample to investigate where this is not working? Because Accumulation option works for Multi tasking and associate engine</P></BODY></HTML> Tue, 21 Nov 2017 01:44:48 GMT https://community.qlik.com/t5/QlikView/Accumulation-Function-with-multiple-dimensions/m-p/1428443#M429952 Anil_Babu_Samineni 2017-11-21T01:44:48Z