Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Calculate Relative Percentages

Hi There, I'm trying to calculate relative percentages in a table.  I'm looking at the NAICS groupings and trying to calculate the relative percentages of companies, based on a company_name field, and facility size, based on a facility_size field.  So I need to sum all of the companies that belong to that specific industry, and then divide it by all of the companies across all industries.   How might I do this?  It needs to be general, as a filter on my dashboard will be industry groupings.

1 Reply
Esteemed Contributor

Re: Calculate Relative Percentages

You can have a table:

As dimension: Indistry

as measure: count(company) / count({1} total company)