topic Re: New Expression - % average of % expression values based on Dimension in QlikView https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513997#M436798 thank you. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thu, 29 Nov 2018 06:00:17 GMT janturon 2018-11-29T06:00:17Z New Expression - % average of % expression values based on Dimension https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513628#M436771 <TABLE><TBODY><TR><TD><STRONG>Dimensions</STRONG></TD><TD><STRONG>Expressions</STRONG></TD></TR><TR><TD><STRONG>Group</STRONG></TD><TD><STRONG>Place</STRONG></TD><TD><STRONG>City</STRONG></TD><TD><STRONG>%OP</STRONG></TD><TD><STRONG>Avg%Op_Group</STRONG></TD></TR><TR><TD>J I NR</TD><TD>014</TD><TD>Horná Kráľová</TD><TD>27,00%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>015</TD><TD>Tlmače</TD><TD>28,80%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>019</TD><TD>Jarok</TD><TD>30,18%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>020</TD><TD>Mojmírovce</TD><TD>24,21%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>022</TD><TD>Hronské Kľačany</TD><TD>26,56%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>025</TD><TD>Čeľadice</TD><TD>30,28%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>027</TD><TD>Hájske</TD><TD>25,77%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>032</TD><TD>Jedľové Kostoľany</TD><TD>28,23%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>034</TD><TD>Žitavany</TD><TD>29,13%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>129</TD><TD>Dolné Štitáre</TD><TD>25,05%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>137</TD><TD>Lovce</TD><TD>26,98%</TD><TD>27,47%</TD></TR><TR><TD>J I NR</TD><TD>Total</TD><TD>-</TD><TD>27,12%</TD><TD>&nbsp;</TD></TR><TR><TD>J II NR</TD><TD>012</TD><TD>Báb</TD><TD>18,39%</TD><TD>24,93%</TD></TR><TR><TD>J II NR</TD><TD>013</TD><TD>Báb</TD><TD>28,45%</TD><TD>24,93%</TD></TR><TR><TD>J II NR</TD><TD>018</TD><TD>Lužianky</TD><TD>25,76%</TD><TD>24,93%</TD></TR><TR><TD>J II NR</TD><TD>125</TD><TD>Podhorany Bádice</TD><TD>27,10%</TD><TD>24,93%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hello, I have table see above....</P><P>&nbsp;</P><P>%OP is this expression:</P><PRE>= (Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}&gt;}MDD) - Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}&gt;}MDD)) / Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}&gt;}MDD)</PRE><P>&nbsp;</P><P>I need help with create expression&nbsp; Avg%Op_Group.</P><P>It means average %OP for Dimension "Group".</P> Sat, 16 Nov 2024 05:06:58 GMT https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513628#M436771 janturon 2024-11-16T05:06:58Z Re: New Expression - % average of % expression values based on Dimension https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513638#M436773 <P>May be try this</P><PRE>=<FONT color="#FF0000">Avg(TOTAL &lt;Group&gt; Aggr(</FONT> (Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}&gt;}MDD) - Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}&gt;}MDD)) / Sum({&lt;Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}&gt;}MDD) <FONT color="#FF0000">, Group, Place, City))</FONT></PRE> Wed, 28 Nov 2018 13:32:12 GMT https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513638#M436773 sunny_talwar 2018-11-28T13:32:12Z Re: New Expression - % average of % expression values based on Dimension https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513997#M436798 thank you. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thu, 29 Nov 2018 06:00:17 GMT https://community.qlik.com/t5/QlikView/New-Expression-average-of-expression-values-based-on-Dimension/m-p/1513997#M436798 janturon 2018-11-29T06:00:17Z