topic % of total when using show all values in QlikView https://community.qlik.com/t5/QlikView/of-total-when-using-show-all-values/m-p/403388#M150062 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm flummoxed with this one....</P><P></P><P>I am trying to create a table to show details for all 'TRUSTS' regardless of what TRUST is selected.</P><P></P><UL><LI>Note that in this situation there will always be one selection in the field HRG_DESCRIPTION</LI><LI>Note the actual selection in TRUST is currently 5 different values</LI></UL><P></P><P>To ensure all values are displayed I have checked the 'Show All Values' on the dimension, my trick now is getting the formula correct!</P><P></P><P>As you can see, the first one is fine, however for some reason the second displays only for one TRUST (Note dimension values blanked)</P><P></P><P><IMG __jive_id="33094" alt="snipa.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/33094_snipa.JPG" /></P><P></P><P>Column Activity code:</P><P></P><PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600539487652607" jivemacro_uid="_13600539487652607"><P>SUM ({&lt; TRUST -= &gt;}[FCE NUMBER])</P></PRE><P></P><P>Column %Activity code</P><PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600539487648694" jivemacro_uid="_13600539487648694"><P>SUM ({&lt;TRUST -= &gt;}[FCE NUMBER])/</P><P></P><P>AGGR(SUM({&lt;TRUST -= &gt;} [FCE NUMBER]),HRG_DESCRIPTION) </P></PRE></BODY></HTML> Tue, 05 Feb 2013 08:44:36 GMT adamdavi3s 2013-02-05T08:44:36Z % of total when using show all values https://community.qlik.com/t5/QlikView/of-total-when-using-show-all-values/m-p/403388#M150062 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm flummoxed with this one....</P><P></P><P>I am trying to create a table to show details for all 'TRUSTS' regardless of what TRUST is selected.</P><P></P><UL><LI>Note that in this situation there will always be one selection in the field HRG_DESCRIPTION</LI><LI>Note the actual selection in TRUST is currently 5 different values</LI></UL><P></P><P>To ensure all values are displayed I have checked the 'Show All Values' on the dimension, my trick now is getting the formula correct!</P><P></P><P>As you can see, the first one is fine, however for some reason the second displays only for one TRUST (Note dimension values blanked)</P><P></P><P><IMG __jive_id="33094" alt="snipa.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/33094_snipa.JPG" /></P><P></P><P>Column Activity code:</P><P></P><PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600539487652607" jivemacro_uid="_13600539487652607"><P>SUM ({&lt; TRUST -= &gt;}[FCE NUMBER])</P></PRE><P></P><P>Column %Activity code</P><PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600539487648694" jivemacro_uid="_13600539487648694"><P>SUM ({&lt;TRUST -= &gt;}[FCE NUMBER])/</P><P></P><P>AGGR(SUM({&lt;TRUST -= &gt;} [FCE NUMBER]),HRG_DESCRIPTION) </P></PRE></BODY></HTML> Tue, 05 Feb 2013 08:44:36 GMT https://community.qlik.com/t5/QlikView/of-total-when-using-show-all-values/m-p/403388#M150062 adamdavi3s 2013-02-05T08:44:36Z