Get values of a field that are not active in another field

[amaaiia]

Hi!

Imagine we have one alternate state default_state and two main fields field1 and field2.

field1 possible values are : 'a', 'b', 'c', 'd', 'e'; and for field2 are: 'a', 'c', 'd', 'e', 'j', 'm'

There are some filters applied for other fields in default_state that makes field1 to be active with the following values: 'a', 'b, 'c'. That is, count({default_state} distinct field1)=3

I need to count the different values of field2 that ARE NOT ACTIVE in field1. Something like this (that I know it doesn't work): count(distinct GetFieldSelections(field2,,,'default_state') - GetFieldSelections(field1,,,'default_state'))=4

I'm using Qlik Sense, so I can't use e() and p() functions

[Or]

"I'm using Qlik Sense, so I can't use e() and p() functions"

I'm not sure why these two things are related. e() and p() are supported in Qlik Sense?

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...