Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Create a Total and then all records can use that Total in calculations

I have a list vendors, and they want to show the % represented of that vendor to Total Count.  So the calculation is (Vendor Sum)/(Total Vendors Sum).

How can I show this for each row (for the vendor)?

2 Replies
whiteline
Honored Contributor II

Re: Create a Total and then all records can use that Total in calculations

If you have only one dimension just use this expression:

=Sum(Vendor)/Sum(total Vendor)

Then go to the Number tab and select Show in Percent checkbox.

Not applicable

Re: Create a Total and then all records can use that Total in calculations

Here is a sample.

Community Browser