Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

% of column

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

2 Replies
sparur
Specialist II
Specialist II

hello Jon,

Yes it possible:

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

sparur
Specialist II
Specialist II

hello Jon,

Yes it possible:

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