topic Re: % of Total in QlikView https://community.qlik.com/t5/QlikView/of-Total/m-p/1395178#M423622 <HTML><HEAD></HEAD><BODY><P>Hi Antonio,</P><P></P><P>Just add the TOTAL inside the SUM. So, it will be like this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(Product Line Sales) / SUM(TOTAL Product Line Sales)</SPAN></P><P></P><P>Pedro</P></BODY></HTML> Wed, 13 Dec 2017 11:23:39 GMT pedrobergo 2017-12-13T11:23:39Z % of Total https://community.qlik.com/t5/QlikView/of-Total/m-p/1395177#M423621 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>i have this table below - really simple.</P><P>I would like to add a column in order to have a % that is basically (Product Line Sales / TOTAL sales (HIPS+KNEE)</P><P>Which is the best syntax to do this?</P><P>Thanks!</P><P></P><P><IMG alt="tabel data.PNG" class="jive-image image-1" src="/legacyfs/online/186778_tabel data.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 13 Dec 2017 10:48:16 GMT https://community.qlik.com/t5/QlikView/of-Total/m-p/1395177#M423621 qlikviewaf 2017-12-13T10:48:16Z Re: % of Total https://community.qlik.com/t5/QlikView/of-Total/m-p/1395178#M423622 <HTML><HEAD></HEAD><BODY><P>Hi Antonio,</P><P></P><P>Just add the TOTAL inside the SUM. So, it will be like this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(Product Line Sales) / SUM(TOTAL Product Line Sales)</SPAN></P><P></P><P>Pedro</P></BODY></HTML> Wed, 13 Dec 2017 11:23:39 GMT https://community.qlik.com/t5/QlikView/of-Total/m-p/1395178#M423622 pedrobergo 2017-12-13T11:23:39Z