topic Re: Create a Total and then all records can use that Total in calculations in QlikView https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409781#M701744 <HTML><HEAD></HEAD><BODY><P>If you have only one dimension just use this expression:</P><P>=Sum(Vendor)/Sum(total Vendor)</P><P></P><P>Then go to the Number tab and select Show in Percent checkbox.</P></BODY></HTML> Fri, 14 Sep 2012 18:24:08 GMT whiteline 2012-09-14T18:24:08Z Create a Total and then all records can use that Total in calculations https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409780#M701743 <HTML><HEAD></HEAD><BODY><P>I have a list vendors, and they want to show the % represented of that vendor to Total Count.&nbsp; So the calculation is (Vendor Sum)/(Total Vendors Sum).</P><P>How can I show this for each row (for the vendor)?</P><P></P></BODY></HTML> Fri, 14 Sep 2012 17:29:44 GMT https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409780#M701743 2012-09-14T17:29:44Z Re: Create a Total and then all records can use that Total in calculations https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409781#M701744 <HTML><HEAD></HEAD><BODY><P>If you have only one dimension just use this expression:</P><P>=Sum(Vendor)/Sum(total Vendor)</P><P></P><P>Then go to the Number tab and select Show in Percent checkbox.</P></BODY></HTML> Fri, 14 Sep 2012 18:24:08 GMT https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409781#M701744 whiteline 2012-09-14T18:24:08Z Re: Create a Total and then all records can use that Total in calculations https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409782#M701745 <HTML><HEAD></HEAD><BODY><P>Here is a sample.</P></BODY></HTML> Fri, 14 Sep 2012 18:25:53 GMT https://community.qlik.com/t5/QlikView/Create-a-Total-and-then-all-records-can-use-that-Total-in/m-p/409782#M701745 2012-09-14T18:25:53Z