topic Re: Calculated Column in QlikView https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241923#M860567 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149376_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>sum(Sales)/sum(Total Sales)</P></BODY></HTML> Fri, 13 Jan 2017 11:23:27 GMT varshavig12 2017-01-13T11:23:27Z Calculated Column https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241922#M860566 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a problem. I need to create calculated column that will show % which will be calculated by Number/ Total.</P><P>Example:</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">95</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">26%</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">94</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">26%</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">46</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">13%</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">29</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8%</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">27%</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">364</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100%</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>A 95 =(95/364)=26%.</P><P>Please help on this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241922#M860566 2020-11-25T16:16:04Z Re: Calculated Column https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241923#M860567 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149376_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>sum(Sales)/sum(Total Sales)</P></BODY></HTML> Fri, 13 Jan 2017 11:23:27 GMT https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241923#M860567 varshavig12 2017-01-13T11:23:27Z Re: Calculated Column https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241924#M860568 <HTML><HEAD></HEAD><BODY><P>=sum(Sales)/Sum(TOTAL(Sales))</P></BODY></HTML> Fri, 13 Jan 2017 11:32:42 GMT https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241924#M860568 khalander 2017-01-13T11:32:42Z Re: Calculated Column https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241925#M860569 <HTML><HEAD></HEAD><BODY><P>Hi Narendra,</P><P></P><P>Use this expression:</P><P></P><P>=sum(Sales)/sum(TOTAL(Sales))</P></BODY></HTML> Fri, 13 Jan 2017 11:49:12 GMT https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241925#M860569 Anonymous 2017-01-13T11:49:12Z Re: Calculated Column https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241926#M860570 <HTML><HEAD></HEAD><BODY><P>Thank you very much both of you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 13 Jan 2017 11:49:47 GMT https://community.qlik.com/t5/QlikView/Calculated-Column/m-p/1241926#M860570 2017-01-13T11:49:47Z