topic Expression help in QlikView

topic Expression help in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/1580504#M442819 <P>Hi All , </P><TABLE><TBODY><TR><TD>quote no</TD><TD>Name</TD><TD>Quoted </TD><TD>%</TD></TR><TR><TD>1</TD><TD>xy</TD><TD>10</TD><TD>10/200</TD></TR><TR><TD>2</TD><TD>xy</TD><TD>80</TD><TD>80/200</TD></TR><TR><TD>3</TD><TD>xy</TD><TD>67</TD><TD>67/200</TD></TR><TR><TD>4</TD><TD>xy</TD><TD>33</TD><TD>33/200</TD></TR><TR><TD>5</TD><TD>xy</TD><TD>10</TD><TD>10/200</TD></TR></TBODY></TABLE><P> </P><P>Need help on the expression . I need the % column to be achieved .<BR />Group by Customer name i need % example - 10 / 200 (Total quoted number) </P><P>Advance Thanks</P> Sat, 16 Nov 2024 03:34:21 GMT kiranpatil123 2024-11-16T03:34:21Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/1580504#M442819 <P>Hi All , </P><TABLE><TBODY><TR><TD>quote no</TD><TD>Name</TD><TD>Quoted </TD><TD>%</TD></TR><TR><TD>1</TD><TD>xy</TD><TD>10</TD><TD>10/200</TD></TR><TR><TD>2</TD><TD>xy</TD><TD>80</TD><TD>80/200</TD></TR><TR><TD>3</TD><TD>xy</TD><TD>67</TD><TD>67/200</TD></TR><TR><TD>4</TD><TD>xy</TD><TD>33</TD><TD>33/200</TD></TR><TR><TD>5</TD><TD>xy</TD><TD>10</TD><TD>10/200</TD></TR></TBODY></TABLE><P> </P><P>Need help on the expression . I need the % column to be achieved .<BR />Group by Customer name i need % example - 10 / 200 (Total quoted number) </P><P>Advance Thanks</P> Sat, 16 Nov 2024 03:34:21 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1580504#M442819 kiranpatil123 2024-11-16T03:34:21Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/1580524#M442823 You need total qualifier.<BR />something like below<BR />Sum(Quoted)/Sum(total<Name> Quoted)<BR /><BR /><A href="https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990</A> Wed, 15 May 2019 14:54:37 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1580524#M442823 dplr-rn 2019-05-15T14:54:37Z