topic % of column in QlikView

% of column

Wed, 02 Jun 2010 11:39:15 GMT

Hello

i am writung a report and have built the following table

Company Service used Count of service used

Where Company and service used are dimensions and count of service used is an expression.

I simply want the count of the services to reflect the % of the overall amount of services used by the company, is this possible?

Jon

sparur — Wed, 02 Jun 2010 12:38:55 GMT

hello Jon,

Yes it possible:

count([Service used]) / count(TOTAL <Company> [Service used])

sparur — Wed, 02 Jun 2010 12:39:11 GMT

hello Jon,

Yes it possible:

count([Service used]) / count(TOTAL <Company> [Service used])