Hi! To exclude a specific subset within a Qlik Sense set analysis expression without entirely removing a whole field value, you can use the implicit exclusion by using a - (minus sign) and specify the subset conditions directly. Here’s how you can integrate it into your existing expression to filter out only the subset {employee_class={'GS'}, region={'Region'}} without removing all GS or all Region.
sum({ < [payroll_status] = {"A"}, MonthEndInd = {1}, [date_month.autoCalendar.Year] = {"$(=$(vSelCurrentYear))"}, [date_month.autoCalendar.Month] = {"$(=$(vSelCurrentMonth))"}, employee_class -= {"GS"}, region -= {"Region"} > } leave_day) In this structure:
-= will exclude only the specific subset from your results without removing all entries with GS in employee_class or Region in region. Implicit Exclusion: By using -=, you specify the conditions you want to exclude from the set. Explanation The above expression will sum leave_day while meeting the following:
Filters for payroll_status as "A" and MonthEndInd as 1. Matches the current year and month selections. Excludes records where employee_class is exactly "GS" and region is exactly "Region" simultaneously, while retaining any other values in employee_class and region.
If you need to exclude a more complex subset, Qlik allows nested set expressions or combinations using * and +.
