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
