topic Re: Expression Total in QlikView https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744484#M265795 <HTML><HEAD></HEAD><BODY><P>Sorry, I need to be more precise. I would like it to show 424,9 / 2000 = 0,21245 or 21,245%</P></BODY></HTML> Wed, 04 Feb 2015 14:19:36 GMT 2015-02-04T14:19:36Z Expression Total https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744481#M265792 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help with the Expression total, how do I get it to be 21,25% instead of 63,90%?</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 530px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border: 0.5pt solid gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">S</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">sum(P)*sum(T)</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">SUM(P)</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 115pt; background-color: whitesmoke;" width="153"><STRONG style="color: #333333; font-family: Tahoma;">Column(1) / Column(2)</STRONG></TD><TD style="border: 0px windowtext; width: 14pt; background-color: transparent;" width="19"></TD><TD style="border: 0px windowtext; width: 48pt; background-color: transparent;" width="64"></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; height: 12.75pt; background-color: whitesmoke;"><STRONG style="font-family: Tahoma;"> </STRONG></TD><TD align="right" class="xl65" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black gainsboro gainsboro; background-color: whitesmoke;"><STRONG style="color: #000000; font-family: Tahoma;">424,90</STRONG></TD><TD align="right" class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black gainsboro gainsboro black; background-color: whitesmoke;"><STRONG style="color: #000000; font-family: Tahoma;">2 000,00</STRONG></TD><TD align="right" class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black gainsboro gainsboro black; background-color: whitesmoke;"><STRONG style="color: #000000; font-family: Tahoma;">63,90%</STRONG></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD align="right" class="xl70" style="border: 0px red; background-color: transparent;"><STRONG style="color: #ff0000;">21,25%</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">a</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">275,60</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">1 300,00</SPAN></TD><TD align="right" class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">21,20%</SPAN></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">b</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">106,50</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">500,00</SPAN></TD><TD align="right" class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">21,30%</SPAN></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">c</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">42,80</SPAN></TD><TD align="right" class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">200,00</SPAN></TD><TD align="right" class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">21,40%</SPAN></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD></TR></TBODY></TABLE><P></P><P>/J</P></BODY></HTML> Wed, 04 Feb 2015 14:04:09 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744481#M265792 2015-02-04T14:04:09Z Re: Expression Total https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744482#M265793 <HTML><HEAD></HEAD><BODY><P>Here it is</P></BODY></HTML> Wed, 04 Feb 2015 14:14:26 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744482#M265793 alexandros17 2015-02-04T14:14:26Z Re: Expression Total https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744483#M265794 <HTML><HEAD></HEAD><BODY><P>You can change the last expression to:</P><P>If(Dimensionality()=0, sum(aggr(sum(P)*sum(T), S))/Sum(P),</P><P> Column(1) / Column(2))</P></BODY></HTML> Wed, 04 Feb 2015 14:17:43 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744483#M265794 rubenmarin 2015-02-04T14:17:43Z Re: Expression Total https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744484#M265795 <HTML><HEAD></HEAD><BODY><P>Sorry, I need to be more precise. I would like it to show 424,9 / 2000 = 0,21245 or 21,245%</P></BODY></HTML> Wed, 04 Feb 2015 14:19:36 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744484#M265795 2015-02-04T14:19:36Z Re: Expression Total https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744485#M265796 <HTML><HEAD></HEAD><BODY><P>Fantastic - Thank you!</P></BODY></HTML> Wed, 04 Feb 2015 14:21:17 GMT https://community.qlik.com/t5/QlikView/Expression-Total/m-p/744485#M265796 2015-02-04T14:21:17Z