Enquiry on the Set Analysis

[QlikSenseBeginner]

I have a sample data as shared below. 

Year	PROGRAMME	EmploymentRateOverall	Top Industry Sectors
2023	ACCOUNTANCY	Working Full-Time in a Permanent job	Financial and Insurance
2023	ACCOUNTANCY	Working Full-Time in a Permanent job	Financial and Insurance
2023	ACCOUNTANCY	Working Full-Time in a Permanent job	Information & Communication
2023	ACCOUNTANCY	Working Full-Time in a Permanent job	Financial and Insurance
2023	ART, DESIGN & MEDIA	Working Full-Time in a Permanent job	Information & Communication
2023	BUSINESS	Working Part-Time in a Permanent job	Information & Communication
2022	ART, DESIGN & MEDIA	Working Full-Time in a Permanent job	Information & Communication
2021	BUSINESS	Working Part-Time in a Permanent job	Financial and Insurance
2021	BUSINESS	Working Full-Time in a Permanent job	Administrative and Support Services Activities
2023	ACCOUNTANCY	Working Part-Time in a Permanent job	Financial and Insurance

Upon user selected the filter where Year = 2023, Programme = Accountancy from the dashboard filter and only taking into account for those people that are only doing full time permanent job.  The end results should show.  

Result:
Financial and Insurance	75%

Working: (3/4) x 100% = 75%

Would the following set analysis be correct? 

Count([Top Industry Sectors]) / Count({$<EmploymentRateOverall = {'Working Full-Time in a Permanent job'}>}EmploymentRateOverall)

[rubenmarin]

Hi, you can use TOTAL to ignore table dimensions, like:

Count([Top Industry Sectors]) / Count(TOTAL {$<EmploymentRateOverall = {'Working Full-Time in a Permanent job'}>} [Top Industry Sectors])

On this kind of percentages I prefer to use the count of the same field, [Top Industry Sectors] in this case.

[QlikSenseBeginner · Accepted solution]

Thank you so much for sharing.  Let me test it out.  Didn't know that the TOTAL will help solve the problem. I still don't understand how this key word TOTAL works in the equation. Are you able to explain?

[rubenmarin · Accepted solution]

Hi, TOTAL is used to ignore chart dimensions. (note that set analysis is used to change selections, not chart dimensions).

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/define-agg...

https://community.qlik.com/t5/Design/The-Aggregation-Scope/ba-p/1467321

In expressions where you want some dimensions to not be ignored you can add those fields between <>, like:

Count([Top Industry Sectors]) / Count(TOTAL <Year> {$<EmploymentRateOverall = {'Working Full-Time in a Permanent job'}>} [Top Industry Sectors])

If the table has Year as Dimension it will calculate the % of each year separatedly.