topic Using dimension limit totals in QlikView https://community.qlik.com/t5/QlikView/Using-dimension-limit-totals/m-p/120578#M756530 <HTML><HEAD></HEAD><BODY><P>So I have an issue trying to use dimension totals in expressions. I basically want to calculate the % split between home and store for each "name" dimension.&nbsp; As you can see in "Named total" I get the correct total, but it will only show for one of the HD dimensions - this happens for all names, there is a total but it only populates either HD or STORE.</P><P>Using the total function in my aggr fills everything with the £4million total value, I want the £181k!</P><P>I need this to populate both fields so I can divide it by the value to get % split of Value in Agricultural (and subsequent dimensions).</P><P></P><P>Please help!</P><P></P><P><IMG alt="Dimensionhelp.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213395_Dimensionhelp.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Using dimension limit totals https://community.qlik.com/t5/QlikView/Using-dimension-limit-totals/m-p/120578#M756530 <HTML><HEAD></HEAD><BODY><P>So I have an issue trying to use dimension totals in expressions. I basically want to calculate the % split between home and store for each "name" dimension.&nbsp; As you can see in "Named total" I get the correct total, but it will only show for one of the HD dimensions - this happens for all names, there is a total but it only populates either HD or STORE.</P><P>Using the total function in my aggr fills everything with the £4million total value, I want the £181k!</P><P>I need this to populate both fields so I can divide it by the value to get % split of Value in Agricultural (and subsequent dimensions).</P><P></P><P>Please help!</P><P></P><P><IMG alt="Dimensionhelp.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213395_Dimensionhelp.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Using-dimension-limit-totals/m-p/120578#M756530 Anonymous 2020-11-25T16:16:04Z