topic Re: Dividing a dimension value by another dimension value in QlikView https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449045#M512962 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">{&lt;category={'a'}&gt;} </SPAN><SPAN style="font-size: 13.3333px;">Total value)/</SPAN>Sum(value) should be enough</P></BODY></HTML> Sat, 28 Oct 2017 10:35:41 GMT Clever_Anjos 2017-10-28T10:35:41Z Dividing a dimension value by another dimension value https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449044#M512961 <HTML><HEAD></HEAD><BODY><P>I want to get the value of the dimension Category='a' and divide for the current dimension category value</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 448px;"><TBODY><TR><TD class="xl65" height="22" style="text-align: center;" width="64"><STRONG>id</STRONG></TD><TD class="xl65" style="border-left: none; text-align: center;" width="64"><STRONG>category</STRONG></TD><TD class="xl65" style="border-left: none; text-align: center;" width="64"><STRONG>value</STRONG></TD><TD class="xl65" style="border-left: none; text-align: center;" width="64"><STRONG>%</STRONG></TD><TD width="64"></TD><TD width="64"></TD><TD width="64"></TD></TR><TR><TD align="right" class="xl63" height="21">1</TD><TD class="xl63">a</TD><TD align="right" class="xl63">25</TD><TD class="xl63"> </TD><TD></TD><TD></TD><TD></TD></TR><TR><TD align="right" class="xl63" height="20">2</TD><TD class="xl63">b</TD><TD align="right" class="xl63">25</TD><TD class="xl63"> </TD><TD></TD><TD></TD><TD></TD></TR><TR><TD align="right" class="xl63" height="20">3</TD><TD class="xl63">c</TD><TD align="right" class="xl63">40</TD><TD class="xl63"> </TD><TD></TD><TD></TD><TD></TD></TR><TR><TD align="right" class="xl63" height="20">4</TD><TD class="xl63">d</TD><TD align="right" class="xl63">15</TD><TD class="xl64">&nbsp;&nbsp; 1,67 </TD><TD colspan="3">"=category a / category d"</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 27 Oct 2017 19:32:52 GMT https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449044#M512961 Anonymous 2017-10-27T19:32:52Z Re: Dividing a dimension value by another dimension value https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449045#M512962 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">{&lt;category={'a'}&gt;} </SPAN><SPAN style="font-size: 13.3333px;">Total value)/</SPAN>Sum(value) should be enough</P></BODY></HTML> Sat, 28 Oct 2017 10:35:41 GMT https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449045#M512962 Clever_Anjos 2017-10-28T10:35:41Z Re: Dividing a dimension value by another dimension value https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449046#M512963 <HTML><HEAD></HEAD><BODY><P>Thanks, Clever.</P></BODY></HTML> Sat, 28 Oct 2017 13:55:43 GMT https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449046#M512963 Anonymous 2017-10-28T13:55:43Z Re: Dividing a dimension value by another dimension value https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449047#M512964 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Mon, 30 Oct 2017 08:38:52 GMT https://community.qlik.com/t5/QlikView/Dividing-a-dimension-value-by-another-dimension-value/m-p/1449047#M512964 oknotsen 2017-10-30T08:38:52Z